Page MenuHomePhabricator
Paste P175

Oracle "shrink" undo tablespace
ActivePublic

Authored by stwalkerster on Dec 28 2017, 11:03 PM.
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;

Event Timeline

stwalkerster created this object with visibility "Public (No Login Required)".
stwalkerster edited the content of this paste. (Show Details)