Re: how can i shirnk your datafile file size?

From: Frank R. <trek1s_at_gmail.com>
Date: Thu, 22 Nov 2007 05:18:07 -0800 (PST)
Message-ID: <987c37eb-e439-4f5c-a43c-589b7ed32abc@w28g2000hsf.googlegroups.com>

>
> 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.

Well, actually "alter table <tbl_name> move tablespace <other_tablespace>;" (and the same for the indexes). IIRC, if you don't include the "tablespace XXX" part in the "move" statement, objects are rebuilt in the same tablespace they are at that moment, sou you would still be unable to drop datafiles from the tablespace.

Greets. Received on Thu Nov 22 2007 - 07:18:07 CST