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: 25568
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: 3727
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: Thu Aug 17 04:48:13 CDT 2017

Total time taken to generate the page: 0.06753 seconds