ORA-600(ktsircinfo_num1)错误

在测试库发现了这个错误，检查trace文件，发现是在进行交换分区的时候出现的，询问了一下同事，发现导致这个问题的原因是在交换分区的时候指定了一个临时表。

如果Oracle进行对临时表执行这个错误，那么在这里应该显示错误信息，指出不应该使用临时表，而不是报一个600错误。

下面这个例子简单的重现问题：

SQL> CREATE TABLE T_PART (ID NUMBER, NAME VARCHAR2(30)) PARTITION BY RANGE(ID)ITPUB个人空间)n q y C Yc:Qz;T"V
  2  (PARTITION P1 VALUES LESS THAN (10),
AjE"DH/D]'nE+J0  3  PARTITION P2 VALUES LESS THAN (MAXVALUE));

表已创建。

SQL> CREATE TABLE T_EXCHANGE (ID NUMBER, NAME VARCHAR2(30));

表已创建。

SQL> INSERT INTO T_PART SELECT ROWNUM, TNAME FROM TAB;

已创建12行。

SQL> COMMIT;

提交完成。

SQL> ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE;

表已更改。

SQL> SELECT COUNT(*) FROM T_EXCHANGE;

  COUNT(*)
F!`c$dO!G!KY%ye0----------ITPUB个人空间&D6X9P
o C$\
         9

SQL> CREATE GLOBAL TEMPORARY TABLE T_EXCHANGE_TEMP (ID NUMBER, NAME VARCHAR2(30));

表已创建。

SQL> ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE_TEMP;ITPUB个人空间^Y\1JH7s:uT
ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE_TEMP
-^Je"RJG0*ITPUB个人空间3?3I"MK D,{T
第1行出现错误:
gc0O%^PR3f0ORA-00600:内部错误代码，参数: [ktsircinfo_num1], [2147483647], [0], [0], [], [], [], []

测试的版本9204，对应的trace文件中的主要信息为：

Dump file e:\oracle\admin\ytk92\udump\ytk92_ora_2280.trcITPUB个人空间VH1N*EgL
Sun Jan 20 01:13:00 2008
MW$C4|
ZG0ORACLE V9.2.0.4.0 - Production vsnsta=0
CNFvk!QB:J
U6~&PT0vsnsql=12 vsnxtr=3ITPUB个人空间v:U4u[` Tu^}
Windows 2000 Version 5.1 Service Pack 2, CPU type 586
fWD V!C$M%N0Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
;xr*d$h+@0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间9P$~ri"D,^t `
JServer Release 9.2.0.4.0 - Production
KP(pfUad7bp0Windows 2000 Version 5.1 Service Pack 2, CPU type 586ITPUB个人空间hmsL'G_h\)y&`^
Instance name: ytk92

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 2280, image: ORACLE.EXE

gP
kA,BWCS3VG/r0*** SESSION ID:(11.135) 2008-01-20 01:13:00.890ITPUB个人空间|;GNVTTw%R{
*** 2008-01-20 01:13:00.890ITPUB个人空间;k;G,y
@b;ZX+D9arIz
ksedmp: internal or fatal error
9R mPD!r6W3[|.hJ0ORA-00600:内部错误代码，参数: [ktsircinfo_num1], [2147483647], [0], [0], [], [], [], []ITPUB个人空间#B9Q4]CR6`g7w
Current SQL statement for this session:
6m-mB*Hr0ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE_TEMPITPUB个人空间(Fe;\NL^%o
----- Call Stack Trace -----ITPUB个人空间$[*\sV6l'`C#s*uyn
calling              call     entry                argument values in hex     
2`1Na)M7d^0location             type     point                (? means dubious value)    ITPUB个人空间~%z1[L7qP]
-------------------- -------- -------------------- ----------------------------ITPUB个人空间+Z%u9pJ*P3s.]
_ksedmp+327          CALLrel  _ksedst+0           
#[9Q JntQP J(u0_ksfdmp.108+14       CALLrel  _ksedmp+0            3ITPUB个人空间*He
q-JR(_
027174D3             CALLreg  00000000             228D20 3
/F8~:Rn3\,e0026ABCC3             CALLrel  02717450             228D20 33B004C1A92D80 3
9Qo_ Qc8`0                                                   4D9C094
}o[5oD-X`,P6@0_ktsircinfo+179      CALLrel  _kgeasnmierr+0       228D20 33B004C1A92D80 3 4
9Cql7y f.FWhZ*Zx~0                                                   7FFFFFFF 4 0 4 0ITPUB个人空间(a]"Bt#a,s
_kkbptsi_pack_tbl_s  CALLrel  _ktsircinfo+0       
P Xn4].{0eg_info+93                                        ITPUB个人空间!_XGy9u]
e I
_atbFMexchange+2586  CALLrel  _kkbptsi_pack_tbl_s  4D9C5B4 6BBD3774ITPUB个人空间-s^O|
j
                              eg_info+0           
$C)[l7NmKfD7t0_atbdrv+6333         CALLrel  _atbFMexchange+0     4D9D9EC 4D9D928 4D9D9D8
Vw}^\-@
yS0                                                   4D9D9E4 6BB99D3C4D9D988ITPUB个人空间+GJ'WsRQ xoo
                                                   4D9D990 4D9D994ITPUB个人空间0n:X2utez
..1.5_1.filter.29+9  CALLrel  _atbdrv+0           
+^-Xns9}wYH%v059                                                ITPUB个人空间R7?QSH!S)x
_opiosq0+2487        CALLrel  _opiexe+0            4 0 4D9DDC8ITPUB个人空间 Y9F$|*~N6D%\
_kpooprx+236         CALLrel  _opiosq0+0           3 E 4D9DE60 24ITPUB个人空间$Za K%XN;~\Fo%}%y-R
_kpoal8+561          CALLrel  _kpooprx+0           4D9E730 4D9E648 43 1 0 24
4YNQOvu#l%j0_opiodr+1244         CALLreg  00000000             5E 14 4D9E72C
5xU
t Ax"u1}0_ttcpip+2554         CALLreg  00000000             5E 14 4D9E72C0ITPUB个人空间:X~Z&x6r0MRq(b
_opitsk+750          CALLrel  _ttcpip+0           ITPUB个人空间hw7VH'arOr&`
_opiino+1547         CALLrel  _opitsk+0            0 0 22EED8336F670 D8 0
`m|7?_!f m v0_opiodr+1244         CALLreg  00000000            3C4 4D9FBD4
A[!k |vE4\p+i#D0_opidrv+563          CALLrel  _opiodr+0           3C4 4D9FBD4 0
)[i7R+Q,D^){0_sou2o+25            CALLrel  _opidrv+0           
0r&t e*F,Xm6p0_opimai+266          CALLrel  _sou2o+0            ITPUB个人空间$|m5~?(Y%G,}W
_OracleThreadStart@  CALLrel  _opimai+0           ITPUB个人空间-B1Dr1W2l
4+961                                             ITPUB个人空间+W/g)x'A GX7S
7C80B680             CALLreg  00000000            
"xF.w"T|i)Od.Iv0 
my!y1f%|b0--------------------- Binary Stack Dump ---------------------

Metalink中的Bug No. 4581483描述了相同的情况。