Housekeeping Oracle DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Housekeeping Oracle DB

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Housekeeping Oracle DB

    Is there a practice of housekeeping the tables in Oracle DB? Means I want to keep records of past 1 year only. Those data which are more than a year will be exported out to a dump file. The current production DB only has the 1 year of data. Can this be done in Oracle? Most of the tables do no have a field for data and time and the housekeeping cannot be done as I cannot write a script to delete data based on time. Does Oracle maintain statistics on each row when the data is updated/created?

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    nope -- if you can't identify which rows to delete, oracle is not going to do it for you.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

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