>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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).