-
delete from table
Hi..
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?
-
hi again....
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.
10X
-
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|