-
Cannot Drop undo Tablespace - urgent
Hi guys,
I had a corrupted undo tablespace so I had to do a switch of undo tablespace. Now I cannot drop the old undo tablespace because it has some active rollback segments '_Sys'. How can I drop this undo tablespace which is offline . This undo tablespace is not letting create exports b'se it still trys to read the datafile assoacited to the oldundo tablespace
any help will be graetly appreciated
Thanks
-
This should do the trick:
1. ALTER SYSTEM SET undo_retention=0
SCOPE=MEMORY;
2. DROP TABLESPACE 'tablespace_name'
INCLUDING CONTENTS AND DATAFILES;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|