RE: table partitions

>From what I understood, he's asking how to put all January records in one partition, all Feb in another etc.
So you end up with 12 partitions for as many years as you wish. I could not think of any other solution then the one he does not want to.

rw

> Your high value for each partition can just be the beginning of every
> month. For example:
>
> CREATE TABLE ACCOUNTS
> (
> STATEMENT_DATE DATE NOT NULL,
> ACCOUNT_NUMBER VARCHAR2(8) NOT NULL,
> BILLING_CYCLE VARCHAR2(2) NOT NULL,

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wartiak Rastislav
  INET: RWartiak_at_cpoj.cz

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