delete from table
i'm running this query monthly, delete from table_name where date_of < given_date;
it is a big table, and the database is managed by the application,how can i compact the database (oracle 8.1.7 on unix) regarding free space on the database file?
i do not want to do truncate, is there a diffrent way?
10X in advance
why do you want to, the space will be re-used when new data is added?
the free space is for ~ 7 % from 1GB, i'm doing this preventing the datafile becoming full, or i have to alter its size or add an extra datafile.
yeah - but why? the free space in the table will get re-used by the new inserts and the datafile wont need to grow.
Anyhow sounds like you need partitions by range on a date so you can drop a partition whenever you want to
Are you talking about resetting the highwatermark?
Assistance is Futile...
Click Here to Expand Forum to Full Width