Re: How to move partition files
Yes, I am thinking about your option.
I select the data with the key of the partition but the key will be a datetime field.
I need to do:
Select * from table where date_field > 'datetime value' AND date_field < 'datetime value'.
With this I will have partition pruning but I will be selecting three partition in the pruning. Example:
p20081001 -> partition having 01-10-2008 date rows
p20081002 -> partition having 02-10-2008 date rows
p20081003 -> partition having 03-10-2008 date rows
I will perform this query to select 02-10-2008 data.
select * from table where date_field > '2008-10-01 23:59:59' AND date_field < '2008-10-03 00:00:01'
Partition pruning will select three partitions but the data will be only from one partition, p20081002.
I am thinking about the fastest process!
Subject
Views
Written By
Posted
12616
March 05, 2008 03:06PM
7327
March 25, 2008 04:50AM
4026
September 30, 2008 10:18AM
4095
October 01, 2008 07:39PM
3901
October 03, 2008 04:26AM
3570
October 05, 2008 08:39PM
Re: How to move partition files
3618
October 08, 2008 10:43AM
3570
October 08, 2008 10:45PM
4371
October 09, 2008 02:15AM
3453
October 21, 2008 09: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.