Re: how can i shirnk your datafile file size?

On Thu, 22 Nov 2007 01:17:58 -0800, Havel Zhang wrote:

> hi all:
>
> 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 an
> error:
> 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?

What do you mean by "cleared"?
Which version?

Depending on the actual contents of your datafile, issuing "alter table <table_name> move;" and "alter index <index_name> rebuild;" for all your tables and indexes might do the trick. Received on Thu Nov 22 2007 - 06:12:44 CST