RE: table partitions

Rick - Well, a simple way to do it might be to create 5 years of partitions, based on date as described. Then map all the Jan partitions to the same tablespace, Feb partitions to the same tablespace, etc. Instead of truncating a partition, just drop it to reclaim the space. Crude, but might meet your needs without adding a new column. If you are still working there in 5 years, then congratulate yourself and create another 5 years of partitions.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, December 16, 2003 11:39 AM To: Multiple recipients of list ORACLE-L

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


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: RStephenson_at_Ovid.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: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.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).