【oracle笔记】创建UNDO表空间

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 ];