[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
