Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> question about less than values in a range partition
Good morning all
Im experimenting with partitioning a table and do not understand the concept of the less than value
Say I have a end_date date field
01-JAN-00 01-JAN-01 01-JAN-02
and I create a range partition
(PARTITION SO00Q1 VALUES LESS THAN (TO_DATE('01-JAN-2000',
'DD-MON-YYYY')),
PARTITION SO01Q1 VALUES LESS THAN (TO_DATE('01-JAN-2001',
'DD-MON-YYYY')),
PARTITION SO02Q1 VALUES LESS THAN (TO_DATE('01-JAN-2002',
'DD-MON-YYYY'))...
My mind is thinking
SO00Q1 will have the desired < jan 2000
But SO01Q1 would have < jan 2001 and since the first partition is less
than 2000
It would include what is in partition 1
And partition 2 would have 1 and 0
Between would make more sence to me
How does the less than N work?
Thanks!
bob
Bob Metelsky Oracle Certified Professional Phone 203-245-5089 ext113 Office 203-245-5000 Continuum Performance Systems Inc http://www.cps92.com PGP Key http://cps92.com/cps109.gpg
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: bmetelsky_at_cps92.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Oct 10 2003 - 11:24:25 CDT