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;