Hi 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.