create tablespace user

 

CREATE TABLESPACE tablespace

  [DATAFILE clause]

  [MINIMUM EXTENT integer[K|M]]

  [BLOCKSIZE integer [K]]

  [LOGGING|NOLOGGING]

  [DEFAULT storage_clause ]

  [ONLINE|OFFLINE]

  [PERMANENT|TEMPORARY]

  [extent_management_clause]

  [segment_management_clause]

 

CREATE TABLESPACE userdata

  DATAFILE '/ora/data01.dbf' SIZE 50M

AUTOEXTEND ON NEXT 5M MAXSIZE 200M;

 

DROP TABLESPACE tablespace

•Obtaining tablespace and datafile information can be obtained by querying the following:

–Tablespaces:

•DBA_TABLESPACES

–Datafile information:

•DBA_DATA_FILES

 

–Data Segment

–Index Segment

–Rollback Segment

–Temporary Segment

 

CREATE USER swetalina

IDENTIFIED BY mamuni

DEFAULT TABLESPACE usr01

TEMPORARY TABLESPACE temp01

QUOTA 10M ON usr01;

Granting Privileges

 

GRANT <role-name> TO swetalina;

 

DROP USER swetalina;