Skip to content

关于分区表最多可拥有多少分区

群里一个小姑娘问起这个问题，分区表最多可以允许有多少个分区，CONCEPTS里有说到相关的信息在“18 Partitioned Tables and Indexes”中：

10g:

Partitioned Tables
Tables can be partitioned into up to 1024K-1 separate partitions.
Any table can be partitioned except those tables containing columns with LONG or LONG RAW datatypes.
You can, however, use tables containing columns with CLOB or BLOB datatypes.
Database Oracle 排障配置与调整 partition tab 数据技术 | Guang Cai Li |