-
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?
-
nope -- if you can't identify which rows to delete, oracle is not going to do it for you.
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
|