Partition Question

From: Hamid Alavi <hamid.alavi_at_quovadx.com>
Date: Wed, 23 Jun 2004 12:27:37 -0500
Message-ID: <C398496DF88AD711908C00065BEEE32CFE9B25@dfwmail.quovadx.com>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jun 23 2004 - 12:15:47 CDT