RE: Partition Question
- From: "Nelson, Allan" <anelson@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 23 Jun 2004 12:24:56 -0500
Use ctas to define the partitions you want on a copy of the table. Drop
the table and rename the ctas version you created.
Allan
-----Original Message-----
=46rom: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Hamid Alavi
Sent: Wednesday, June 23, 2004 12:28 PM
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=3F
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/
=46AQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed
and may contain confidential and/or privileged information. Copying,
forwarding or distributing this message by persons or entities other than the
addressee is prohibited. If you have received this email in error, please
contact the sender immediately and delete the material from any computer. This
email may have been monitored for policy compliance. [021216]
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
