Hi,

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.