Home » RDBMS Server » Server Administration » Partition Maintenance (Oracle 10203)
Partition Maintenance [message #406539] Thu, 04 June 2009 08:53 Go to next message
bella13
Messages: 90
Registered: July 2005
Member
I have a table, each day has 5 million rows. At any given day i need to retain only prior 7days of
data. The data volume is huge to purge with a delete. So i intend to drop partitions / truncate
partitions that do not fall in the prior 7 day bucket.

Today being June 4th; i have to retain prior 7 days ; that is data from May 28 onwards.

If date was June 5th i have to retain prior 7 days ; that is data from May 29 onwards.And so on..

Since the partition key changes; how can i define this kind of partition?

Hope you can help, thanks

B>>
Re: Partition Maintenance [message #406543 is a reply to message #406539] Thu, 04 June 2009 09:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=24757

Regards
Michel
Re: Partition Maintenance [message #406550 is a reply to message #406543] Thu, 04 June 2009 10:12 Go to previous message
bella13
Messages: 90
Registered: July 2005
Member
this is great! thank you
Previous Topic: LMT and Extents size problems
Next Topic: Maximum session exceeded
Goto Forum:
  


Current Time: Sun Dec 08 05:54:49 CST 2024