Open Source Content Management

SELECT tablespace_name, file_name, bytes/1024/1024 AS size_mb FROM dba_data_files  WHERE tablespace_name = 'UNDOTBS1';

CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/path/to/undotbs02.dbf' SIZE 10G;

ALTER SYSTEM SET UNDO_TABLESPACE = UNDOTBS2;

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

SELECT tablespace_name, file_name, bytes/1024/1024 AS size_mb FROM dba_data_files;

ALTER SYSTEM SET UNDO_RETENTION = 3600 SCOPE=BOTH;