|Subject:||how can i shirnk your datafile file size?|
|Posted by:||Havel Zhang (havel.zha…@gmail.com)|
|Date:||Thu, 22 Nov 2007|
I have a tablespace have a datafile sizing 8GB, but actually, I just
using 2GB data. But when i resize that data file, oracle will return
Failed to commit: ORA-03297: file contains used data beyond requested
RESIZE value .
I have search the table dba_segment, and cleared all tables/indexes on
that datafile, but still can not shirnk this datafile.
Can u help me?