RE: Maximum number of partitions?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Jul 2004 08:06:55 -0500
Eric
My experience is that you'll find you can create a lot more partitions
than you can manage. Carefully consider your management strategy.
Dennis Williams
DBA
Lifetouch, Inc.
Does believing you're the last sane man on the planet make you crazy?
Del Spooner in I Robot, played by Will Smith
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Justin Cave
Sent: Monday, July 19, 2004 11:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Maximum number of partitions?
According to the Oracle Reference
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44.htm
#288033, 64k - 1
Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Yen, Eric
Sent: Monday, July 19, 2004 10:16 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Maximum number of partitions?
We are about to List Partition a table that has 78 million rows.
Has anyone heard if there is a maximum number of partitions that a table can
have in Oracle 9.2.0.4. ?
Please site source if possible.
Eric Yen
----------------------------------------------------------------
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
-----------------------------------------------------------------
Other related posts:
