Re: Partition by Date Column
I changed my partitionning scheme for database pruning, but it still doesn't like I'd like it to.
I switched to using "partition by range (yearweek(date))".
Selecting one day works with pruning. Selecting a range makes all the partitions to be scanned.
I also have "corruption" when using "explain partitions select blablabla" that looks like this :
r?s\?p200627,p200628,p200629
Any idea why? What did I do wrong?
Subject
Views
Written By
Posted
17653
July 05, 2006 10:23AM
5844
July 24, 2006 09:01AM
5270
September 04, 2006 09:56PM
4602
September 05, 2006 05:07PM
6117
September 06, 2006 01:34AM
4168
October 03, 2006 12:06PM
5188
October 03, 2006 09:04PM
Re: Partition by Date Column
4048
October 25, 2006 08:45AM
3964
October 26, 2006 11:24PM
3819
January 28, 2009 02:08AM
3856
March 19, 2009 01:35AM
3647
April 06, 2009 08:15AM
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.