#736

[Oracle] UNDO tablespace

Create new TBS :

create undo tablespace UNDO_RBS1 datafile '/path/to/file.dbf' size 1000m AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

Set as default undo tablespace :

alter system set undo_tablespace=undo_rbs1;

Retrieve the old one

SELECT tablespace_name, file_name FROM dba_data_files WHERE tablespace_name like 'UNDO%';

Drop it

drop tablespace XXX;

or :

DROP TABLESPACE XXX INCLUDING CONTENTS AND DATAFILES;