The 10g Reference Guide, although it might be outdated, still says: "Maximum number of partitions allowed per table or index: 64 KB - 1 partitions" Actually I wonder how the scientists in Oracle have managed to create an entirely new measurement unit for partition counts: KB e.g. KelvinByte? How can you actually substract one "partition" from an amount of information at specific temperature? Or has 10g adapted a new, informational-temperatural model instead of the old object-relational one? Tanel. > 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 ---------------------------------------------------------------- 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 -----------------------------------------------------------------