I notice that my UNDO datafile has grown from 200MB to 1GB. I tried to reduce the size but it doesn't allow. How can I strink the file back to 200MB or drop and recreate back? I'm not allow to offline the tablespace and thus cannot delete.
1. Create a new undo tablespace
2. Change the 'undo_tablespace' parameter to the new tablespace name.
3. Drop the old tablespace (obviously you will have to have no active transactions in this tablespace before you can do this)
Oracle Certified Professional "Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"