Re: Proactive partitioning by Week
Thanks Jon and Mikael for your awesome responses. I will use TO_DAYS as you recommend for my partition.
PARTITION BY RANGE(TO_DAYS(m_date)) (
...
)
When I move to 5.1 (at release), I am going to create a mirror of the old table with the new partitioning (and precreated partitions for the past six months), and then SELECT .. INTO the new, partitioned table.
The only thing that I am having a concern with is Jon's reference to the key constraints. Would my current table structure not conform? I have a key on m_date...
Subject
Views
Written By
Posted
5326
June 08, 2007 04:14PM
3993
June 12, 2007 12:01AM
3992
June 12, 2007 01:57AM
Re: Proactive partitioning by Week
3185
June 13, 2007 11:14AM
3285
June 14, 2007 02:47PM
3180
June 14, 2007 03:29PM
3309
July 02, 2007 01:46PM
4833
July 03, 2007 01:21AM
3212
July 03, 2007 08:43AM
3244
July 05, 2007 03:22AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.