Alternatively you could create the table based on a time_key and map that to the time table. Then the partitions key could change meaning as the years go by.
i.e. time_key 1 = January of 2004
time_key 2 = Februrary of 2004
...
truncate the partitions as needed and reuse by changing the date in the time table.
time_key 1 = January of 2005
time_key 2 = Feburary of 2005
DENNIS WILLIAMS <DWILLIAMS@LIFETOUCH.COM> wrote:
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@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@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@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-ma!
il 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@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@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@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@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).
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: M.Godlewski
INET: mcgodlewski_at_yahoo.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).
Received on Tue Dec 16 2003 - 12:49:33 CST
