Create new undo tablespace and remove the old one
741376Jul 8 2010 — edited Jul 8 2010Hi every body,
on our database undo tablespace is very big and had many data files and the disk becomes full. to release space, i want to create new undo tablespace and want to remove the old one with its datafiles from disk. can i do that please and if yes, how to proceed a process step by step is welcome.
My database version is 11g and it's on an Linux RHE 5.
it's not a RAC database and the undo tablespace is UNDOTBS1.
Thank you.