undo tablespace management in oracle
Creating an UNO TABLESPACE
SQL> CREATE UNDO TABLESPACE undotbs DATAFILE '/u01/oradata/orcl/undotbs.dbf' SIZE 50m;
Altering an UNDO TABLESPACE
SQL> ALTER TABLESPACE undotbs ADD DATAFILE '/u01/oradata/orcl/undotbs_01.dbf' SIZE 30M;
(OR)
SQL> ALTER TABLESPACE undotbs ADD DATAFILE '/u01/oradata/orcl/undotbs_01.dbf' RESIZE 50M;
Droping an UNDO TABLESPACE
SQL> DROP TABLESPACE undotbs; ( For Logically tablespace drop)
SQL> DROP TABLESPACE undotbs INCLUDING CONTENTS AND DATAFILE; ( For Logical and physical drop)
Switching Undo Tablespaces
SQL> ALTER SYSTEM SET UNDO_TABLESPACE = undotbs1
UNDO_MANAGEMENT (If AUTO), use automatic undo management mode.
(If MANUAL), use manual undo management mode. The default is MANUAL.
UNDO_TABLESPACE Is An optional dynamic parameter specifying the name of an undo tablespace to use. This parameter should be used only when the database has multiple undo tablespaces and you want to direct the database instance to use a particular undo tablespace.
UNDO_RETENTION Is a dynamic parameter specifying the minimum length of time to retain undo. The default is 900 seconds. The setting of this parameter should take into account any flashback requirements of the system.
HTML Comment Box is loading comments...