DB: 10G release 2
OS: Windows 2003 Server
We have table which carries size approx. 50GB in 13 Datafiles, now, i truncate table, tablespace total size is 75GB, after truncate size change to 25GB.
I try to resize datafile but get error "ORA-03297: file contains used data beyond requested RESIZE value".
Do i need to reorganize the datafiles? or other suggestion will be appreciated