Yes, this is what I was looking for. I don't care about the year, and don't want to worry about adding new partitions for every new month that comes along each year. This table will only needs to contain six months worth of data. I will not be archiving it at all. I wanted to truncate the data/partition after it was 6 months old.
Thanks, Rick Stephenson -----Original Message----- Sent: Tuesday, December 16, 2003 6:49 AM To: Multiple recipients of list ORACLE-L >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). This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, forwarding or otherwise distributing or taking any action in reliance on the contents of this information is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rick Stephenson 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).
