Home » Other » General » Data Purging - In order to overcome growth of Data of certain timeframe (oracle9i)
Data Purging - In order to overcome growth of Data of certain timeframe [message #389722] Tue, 03 March 2009 06:53 Go to next message
tapaskmanna
Messages: 98
Registered: January 2007
Location: Cyprus,Nicosia
Member
Data is growing drastically (i.e. like 80Gb) after every timeframe of 20 Days.
In order to overcome the scenario, Data Purging needs to be implemented.
Can anybody suggest, what all the measure should take care for Data Purging?

Re: Data Purging - In order to overcome growth of Data of certain timeframe [message #389766 is a reply to message #389722] Tue, 03 March 2009 08:47 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>what all the measure should take care for Data Purging?
Do not delete any data that you may want to access in the future.
Re: Data Purging - In order to overcome growth of Data of certain timeframe [message #389909 is a reply to message #389766] Wed, 04 March 2009 01:19 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Partitioning tables by date and then dropping old partitions is a crude but popular purging/archiving technique.

Ross Leishman
Previous Topic: frontend for intranet
Next Topic: Data Archving Tool By Oracle
Goto Forum:
  


Current Time: Fri Dec 09 19:15:27 CST 2016

Total time taken to generate the page: 0.21182 seconds