Page MenuHomePhabricator

Oracle "shrink" undo tablespace

Authored By
stwalkerster
Dec 28 2017, 11:03 PM
Size
428 B
Referenced Files
None
Subscribers
None

Oracle "shrink" undo tablespace

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u01/app/oracle/oradata/XE/UNDOTBS2_1.dbf' SIZE 10485760;
ALTER SYSTEM SET UNDO_TABLESPACE=UNDOTBS2 SCOPE=BOTH;
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;
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
41837
Default Alt Text
Oracle "shrink" undo tablespace (428 B)

Event Timeline