DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: delete from table

  1. #1
    Join Date
    Feb 2005
    Posts
    31

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why do you want to, the space will be re-used when new data is added?

  3. #3
    Join Date
    Feb 2005
    Posts
    31
    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

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    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

  5. #5
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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
  •  


Click Here to Expand Forum to Full Width