The Fei's Tech Notes
Monday, November 13, 2017
Oracle Database: Switch UNDO Tablespace online
CREATE UNDO TABLESPACE UNDOTBSNEW DATAFILE '/DATAFILES/UNDOTBSNEW.DBF' AUTOEXTEND ON NEXT 100M SIZE 4096M;
ALTER SYSTEM SET UNDO_TABLESPACE= UNDOTBSNEW;
DROP TABLESPACE UNDOTBSOLD INCLUDING CONTENTS AND DATAFILES;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment