FAQ
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).

Search Discussions

  • Rothouse, Michael at Oct 10, 2003 at 4:49 pm
    Look at it in terms of an IF statement. Once the criteria has been met,
    you exit the IF and the record is assigned to that corresponding
    partition.

    -----Original Message-----
    Sent: Friday, October 10, 2003 12:24 PM
    To: Multiple recipients of list ORACLE-L

    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).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rothouse, Michael
    INET: mrothouse_at_fcg.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).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 10, '03 at 4:24p
activeOct 10, '03 at 4:49p
posts2
users2
websiteoracle.com

2 users in discussion

Rothouse, Michael: 1 post Bob Metelsky: 1 post

People

Translate

site design / logo © 2022 Grokbase