Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> question about less than values in a range partition

question about less than values in a range partition

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Fri, 10 Oct 2003 08:24:25 -0800
Message-ID: <F001.005D2B6C.20031010082425@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US