Question: I ant to know the
maximum number of possible partitions in an Oracle table.
What is the max partitions?
Answer: Oracle states that the maximum number of
partitions/subpartitions is expressed as:
Oracle9i - Oracle10gr2: I64K - 1 (65535 max
Oracle11g and beyond: (1,024 K-1) = 1,048,575
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.