RE: Maximum number of partitions?

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: