RE: Maximum number of partitions?

From: Justin Cave <justin_at_askddbc.com>
Date: Mon, 19 Jul 2004 22:28:53 -0600
Message-Id: <20040720040549.EDEC572C1C9@turing.freelists.org>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Yen, Eric
Sent: Monday, July 19, 2004 10:16 PM
To: oracle-l_at_freelists.org
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_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

---

---

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 Mon Jul 19 2004 - 23:28:24 CDT