Basic syntax for Oracle tablespace users

To create a temporary tablespace:

Create temporary tablespace mdm_temp

Tempfile '/u01/app/oracle/tempspace/mdm_temp.dbf '

size m

Autoextend on

next 50 maxsize 20480

extent management local;

To create a table space:

Create tablespace MDM

Logging

datafile '/u01/app/oracle/tablespace/mdm.dbf '

size m

Autoextend on

next 50 maxsize 20480

extent management local;

To create a user:

create user identified by

& nbsp;       default    MDM

temporary tablespace mdm_temp;

To authorize the user:

Grant Connect,resource, dba to MDM ;

Delete User

Drop user MDM cascade;

Delete Table space

Drop tablespace mdm including contents and datafiles;

Query table space Name:

Select tablespace_name from Dba_tablespaces;

This article is from "Night Carving Dusk" blog, please make sure to keep this source http://amxiaoha.blog.51cto.com/7109979/1587653

Basic syntax for Oracle tablespace users