Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P175
Oracle "shrink" undo tablespace
Active
Public
Actions
Authored by
stwalkerster
on Dec 28 2017, 11:03 PM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Tags
None
Subscribers
None
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 paste.
Dec 28 2017, 11:03 PM
2017-12-28 23:03:33 (UTC+0)
stwalkerster
created this object with visibility "Public (No Login Required)".
stwalkerster
edited the content of this paste.
(Show Details)
Log In to Comment