I confirmed that Oracle Supported test to a practical limit of 1000 = partitions / subpartitions. We have tested 250 partitions without any problems. Thanks!!!! -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx = [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Mogens N=F8rgaard Sent: Tuesday, July 20, 2004 12:56 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: Maximum number of partitions? I think the 64K limit is lifted in 10g. Mogens Justin Cave wrote: > According to the Oracle Reference > = http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch44.= htm > #288033, 64k - 1=20 >=20 >=20 ---------------------------------------------------------------- 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 -----------------------------------------------------------------