Re: Partitioning by year and day
Hey Rick,
I'm looking at 100M+ rows per day.
What I meant about the insert/selects was, if I only did day partitioning and created duplicate tables by years, I would have to dynamically choose the table based on the year I was looking up.
I think the solution here, then, is one table partitioned by year and day, and the daily script you mentioned to add a new and remove the old partition to prevent hitting the limit.
Thanks!
Subject
Views
Written By
Posted
4814
June 16, 2011 01:52AM
2147
June 17, 2011 09:34AM
Re: Partitioning by year and day
2084
June 17, 2011 09:48AM
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.