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
‹
›
Home
View web version
No comments:
Post a Comment