now when i am resizing the datafile to 1GB i am getting this error..
SQL> ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M;
ALTER DATABASE DATAFILE '/oradata/u01/undo01.dbf' RESIZE 1024M
ERROR at line 1:
ORA-03297: file contains used data beyond requested RESIZE value
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.