nice articles. one more thing: Everyone who has ever asked me to put up a 12 component cyclical based on month really wanted at least 13, and usually 16 (which is 5 complete rolling quarters plus a place for the newest inserts.) By making each component its own tablespace or two (where component may refer to several periodically cycled table and index partitions), you can also have the luxury of making components read only and taking them off line or relegating them to read only media for reference. With one a month, there is a good chance that Oracle will stay ahead of you with the practical limits for reasonable processing on the number of partitions. You may also want to join the voting pool that would like Oracle to be able to efficiently assemble global indexes from indexes local to a partition, so that if you have cross partition access needs, you'll have a reasonable way attack them. mwf -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Yen, Eric Sent: Wednesday, June 23, 2004 2:26 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Partition Question Two real solid article on how to do this and real life considerations. http://www.dbazine.com/nanda6.shtml http://www.dbazine.com/nanda7.shtml -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lex de Haan Sent: Wednesday, June 23, 2004 10:30 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: Partition Question Hi Hamid, this sounds like range partitioning to me ... if you say you want to always have 12 partitions, I am getting a little bit "nervous" -- I guess you mean that you want to add a new partition each time, while dropping one partition at the end, right? in other words, you don't "reuse" partitions. =20 Kind regards, Lex. =20 --------------------------------------------- visit my website at http://www.naturaljoin.nl <http://www.naturaljoin.nl>=20 --------------------------------------------- =20 -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Hamid Alavi Sent: Wednesday, June 23, 2004 18:28 To: 'Oracle-L (E-mail) Subject: Partition Question List - I have a column in all of my tables named partition_date but I want to partition tables based on the Month of this Date any body have any Idea? I want to have always 12 partition for each table Independent from a date Just Month .One partition for month 01, another for Month 02 etc till Month 12 then the next year is back again to Month 01 with using the partition date in each table my partition_date is TRUNC(sysdate). Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- -- Binary/unsupported file stripped by Ecartis -- -- Type: text/x-vcard -- File: Lex de Haan.vcf ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------