Re: range columns including datetime column
Posted by:
Rob Voyer
Date: August 16, 2012 09:54AM
That is a good suggestion, but period is (5-hourly, 4-daily, 3-weekly, 2-monthly, 1-yearly). So I keep the 1-3 data forever, but the 4,5 data I kill after 3 months as it is the majority of the data. So I really only need the rotating partitions for the 4,5 periods, hence the structure I came up with.
I think it would make sense for my initial idea to work, essentially a bubbling up as high as it can go in the rules. Or perhaps allowing a reuse of a partition in more than one spot in the partition rules. That might be tricky though but possibly more flexible. Thanks for your help.
Subject
Views
Written By
Posted
3108
August 15, 2012 10:01PM
1670
August 16, 2012 02:42AM
1591
August 16, 2012 07:15AM
1594
August 16, 2012 09:35AM
Re: range columns including datetime column
1539
August 16, 2012 09:54AM
1616
August 19, 2012 10:55PM
1494
August 20, 2012 03:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.