Re: Partitioning table by timestamp column type
Posted by:
Rick James
Date: March 25, 2011 09:14AM
Alas, nothing automatic about creating future PARTITIONs. You should create a cron jobs for such.
Also, note that there is a limit of 1024 partitions, so you cannot even get to 3 years' worth of partitions.
Prematurely creating partitions leads to some queries doing extra work to check the empty partitions.
If you are not using the partitions to facilitate dropping old data, why do you want to PARTITION?
Subject
Views
Written By
Posted
4048
March 24, 2011 07:00AM
Re: Partitioning table by timestamp column type
1991
March 25, 2011 09:14AM
1781
March 25, 2011 03:03PM
1522
March 25, 2011 07:02PM
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.