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?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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: 3728
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 04:26:08 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.