RE: Partition Question
- From: "Yen, Eric" <EYen@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 11:26:23 -0700
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
-----------------------------------------------------------------
Other related posts:
