Deleting UNDOTBS

[TomNJerry]

No no. Its a confusion. See - My original undo tablespace was UNDOTBS.
And the one i created newly is - UNDOTBS1. Since I need to drop UNDOTBS (not UNDOTBS1) , I executed your queries for UNDOTBS. If you have doubt, following is what I did and documented as per Tim and Pando's advice:



Step 1:
CREATE UNDO
TABLESPACE "UNDOTBS1"
DATAFILE 'D:\UNDOTBS\UNDOTBS05.DBF' SIZE 200M
REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE 16383M

Check in the Enterprise manager consol if the tablespace is created.

Step 2: Fire a COMMIT query to ensure that all transections are commited.

Step 3: Tell the system to use the new tablespace
ALTER SYSTEM SET undo_tablespace=UNDOTBS1;

Step 4: Restart the DB. Just for safty.

Step 5: Drop the table old space
DROP TABLESPACE UNDOTBS INCLUDING CONTENTS AND DATAFILES;

Step 6: Restart the DB. Check if it opens properly. Fire some DDL query.

Step 7: Delete the old datafiles from the filesystem. If not sure about the filename check from the view dba_data_files.

Step 8: Restart the DB.

I got stucked in step 5