-
Best practices for Housekeeping.
Hi All!
What exactly is housekeeping ? Is is something like cleaning up of unwanted data and archiving them or simply deleting unwanted data depending upon the requirement.
To be honest, never done this thing before so wanted to know what you guys do for housekeeping ? The Do's and Don'ts ? Any link or document would be helpful.
Amar
"There is a difference between knowing the path and walking the path."
-
Hi Amar,
We have done the housekeeping before on the Ingres databases. It was the process of archiving the old/historic data (eg: retaining only current and previous years data). We had to create temporary tables based on the tables (eg: inventory_master_1998 for inventory_master) and backup the table and delete the data from the regular tables.
This was a massive exercise and we used to a good 2 days to complete it.
We had to restore (at times) to different machines for the reporting purposes- Your understanding is correct, however I have not seen any documents, but it's fairly a common practice in some of the companies. Hopefully, others would share their practices.
Badrinath
There is always a better way to do the things.
-
Amar, Selective export has made it pretty easy. You can export the historical data to dump files using QUERY option and delete them from tables. You can archive the dump fils to tape that can be restored if required.
If you are using partitioning then its even simpler just export the partition archive them and drop them.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
Thanks Bardri, Thanks Sanjay.
Its more clear now, but then again the same problems will arise, ie deleting of millions of historic data. Now i can see the problems comming.
I think i should be looking for best practices for deleting huge ammount of data rather than best practices for Housekeeping
Hmmm i think now i need to know more about datawarehousing. Slimedave, any suggestions on housekeeping and datawarehousing .
Regards
Amar
"There is a difference between knowing the path and walking the path."
-
Wait till you see Sanjay in his French maids outfit, woo hoo!
MH
I remember when this place was cool.
-
-
Originally posted by adewri
Hmmm... i was thinking rather than deleting millions of rows, why not create a new table and insert rows that i want to keep and drop the old table itself. After all insert is faster than delete.
What happens when by any chance you need your old data...or....Just take a full export dump before the thought mentioned by you...being at the safer side...you know...
"Greatest Rewards come only with Greatest Commitments!"
-
Originally posted by sandycrab
What happens when by any chance you need your old data...or....Just take a full export dump before the thought mentioned by you...being at the safer side...you know...
Yes of course that would include two inserts then, one for the data that i want to keep on the current DB and the other one for data that i don't want to keep and copy them to remote archival DB, then drop the old one and rename the new one to the old one.
Thanks for reminding this point.
Amar
"There is a difference between knowing the path and walking the path."
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
|