Oracle "shrink" undo tablespace
No One
Actions

Authored By

	stwalkerster
	Dec 28 2017, 11:04 PM

Size

574 B

Referenced Files

None

Subscribers

None

Oracle "shrink" undo tablespace
View Options

	CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/XE/UNDOTBS2_1.dbf' SIZE 10485760;

	ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2 SCOPE=BOTH;

	-- kill all sessions

	-- wait for value of undo_retention (default 900)

	DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

	CREATE UNDO TABLESPACE UNDOTBS1 DATAFILE '/u01/app/oracle/oradata/XE/UNDOTBS1.dbf' SIZE 10485760;

	ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS1 SCOPE=BOTH;

	-- kill all sessions

	-- wait for value of undo_retention (default 900)

	DROP TABLESPACE UNDOTBS2 INCLUDING CONTENTS AND DATAFILES;

File Metadata

Mime Type: text/plain; charset=utf-8
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 41838
Default Alt Text: Oracle "shrink" undo tablespace (574 B)

Event Timeline