I got a scnearao I have accidentally added multiple datafiles to the undo table space and due to that the oradata directory got filled up to 90% and we are getting the alerts. Its a oracle 9i PRODUCTIONdatabase and a regular filesystem. i TRIED TO RESIZE THE DATAFILES but getting ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value..
let me know how can i avoid this situation