[20170703]ora-00600[kkpamDGSPam2].txt

--//oracle 分区数量不能超过1048575.做一个例子说明:
--//2^20-1=1048575

SCOTT@test01p> @ ver1

PORT_STRING                    VERSION        BANNER                                                                               CON_ID
------------------------------ -------------- -------------------------------------------------------------------------------- ----------
IBMPC/WIN_NT64-9.1.0           12.1.0.1.0     Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production              0

drop table t1 purge;
CREATE TABLE T1 ( ID NUMBER,CODE VARCHAR2(1)) partition by range(ID) interval(1)
SUBPARTITION BY LIST(CODE)
SUBPARTITION TEMPLATE
(SUBPARTITION CODE_a VALUES ('A'),
SUBPARTITION CODE_s VALUES ('S'),
SUBPARTITION CODE_v VALUES ('V'),
SUBPARTITION CODE_e VALUES ('E'),
SUBPARTITION CODE_oth VALUES (DEFAULT))
(partition ID_1 values less than (1));

2.测试:
SCOTT@test01p> select * from t1 where id=1048575 and code='A';
select * from t1 where id=1048575 and code='A'
              *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkpamDGSPam2], [1048575], [1048575], [], [], [], [], [], [], [], [], []

SCOTT@test01p> select * from t1 where id=1048577 and code='A';
select * from t1 where id=1048577 and code='A'
              *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkpamDGSPam2], [1048576], [1048575], [], [], [], [], [], [], [], [], []

SCOTT@test01p> select * from t1 where id=2048575 and code='A';
select * from t1 where id=2048575 and code='A'
              *
ERROR at line 1:
ORA-00600: internal error code, arguments: [kkpamDGSPam2], [1048576], [1048575], [], [], [], [], [], [], [], [], []
--//可以只要超出范围1048575,参数就是1048576.

SCOTT@test01p> select * from t1 where id=1048574 and code='A';
no rows selected