CREATE [ BIGFILE | SMALLFILE ] UNDO TABLESPACE undotbs02
DATAFILE '/u01/app/oracle/oradata/orcl/undotbs02.dbf'
SIZE 50M
EXTENT MANAGEMENT DICTIONARY | LOCAL [ AUTOALLOCATE | UNIFORM SIZE size ]
RETENTION GUARANTEE | UNGUARANTEE;
只有在OPEN状态才可以进行创建表空间操作,
删除表空间
DROP TABLESPACE undotbs02 [ INCLUDING CONTENTS [ AND DATAFILES ] CASCADE CONSTRAINTS ];