ORA-600(ktsircinfo_num1)错误

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

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

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

SQL> CREATE TABLE T_PART (ID NUMBER, NAME VARCHAR2(30)) PARTITION BY RANGE(ID)ITPUB个人空间/B5z~Hf-S,K
  2  (PARTITION P1 VALUES LESS THAN (10),ITPUB个人空间@IQ%qJ7q
  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(*)
+g_!xQ;TW"a0----------
%PR;_8qT*Q]4oV-R+Q0         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;
r$W(`@UPc0ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE_TEMP
4MQ-zR{0*
6L9}dl{%I^#Dd0第1行出现错误:
zt5j` Bn0ORA-00600:内部错误代码，参数: [ktsircinfo_num1], [2147483647], [0], [0], [], [], [], []

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

Dump file e:\oracle\admin\ytk92\udump\ytk92_ora_2280.trc
yf6Z?d6b"xc0Sun Jan 20 01:13:00 2008
3dc~$Pt5U#T,U(@0ORACLE V9.2.0.4.0 - Production vsnsta=0
0q&[e8n?8f0vsnsql=12 vsnxtr=3ITPUB个人空间\E6f+n M0d4lR v2K7D#Tq
Windows 2000 Version 5.1 Service Pack 2, CPU type 586ITPUB个人空间9B`$AYD){I"l T
Mt
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
G!DL~)a"b0With the Partitioning, OLAP and Oracle Data Mining optionsITPUB个人空间_ dc![ p
JServer Release 9.2.0.4.0 - Production
-Y#[fWHsK d0Windows 2000 Version 5.1 Service Pack 2, CPU type 586ITPUB个人空间
~0b(sn?s
Instance name: ytk92

Redo thread mounted by this instance: 1

Oracle process number: 14

Windows thread id: 2280, image: ORACLE.EXE

8b?F+A:x R5_,@9B.L9F0*** SESSION ID:(11.135) 2008-01-20 01:13:00.890
%IhL#W ^{
__fk{0*** 2008-01-20 01:13:00.890ITPUB个人空间6[Um]+L n.e*`-b
ksedmp: internal or fatal errorITPUB个人空间PGI.eTs2F
ORA-00600:内部错误代码，参数: [ktsircinfo_num1], [2147483647], [0], [0], [], [], [], []ITPUB个人空间N"|bh)z#Z P
Current SQL statement for this session:
? m&C x f4[al0ALTER TABLE T_PART EXCHANGE PARTITION P1 WITH TABLE T_EXCHANGE_TEMP
ec?L;x1?7Iyhg0----- Call Stack Trace -----ITPUB个人空间M{ Z`#_/s+w4b;|
calling              call     entry                argument values in hex     
2F;R;A
M'U.j0location             type     point                (? means dubious value)    
x9~g ~O'M|0-------------------- -------- -------------------- ----------------------------ITPUB个人空间0e9Y"i`7^G"d
_ksedmp+327          CALLrel  _ksedst+0           
J
ij|E~0_ksfdmp.108+14       CALLrel  _ksedmp+0            3
_#X!^{e&C!e;j1u\0027174D3             CALLreg  00000000             228D20 3
)]L5S%g7e0026ABCC3             CALLrel  02717450             228D20 33B004C1A92D80 3ITPUB个人空间ag)W;c'hyxuB
                                                   4D9C094
^:B0Y%`$k-\'GR}0_ktsircinfo+179      CALLrel  _kgeasnmierr+0       228D20 33B004C1A92D80 3 4
X9b`.HS:b@t+n$t{ ^0                                                   7FFFFFFF 4 0 4 0
S`
\QA/s2?0_kkbptsi_pack_tbl_s  CALLrel  _ktsircinfo+0       ITPUB个人空间+x l#v_ sH!q#M
eg_info+93                                        ITPUB个人空间'e0g_)Dz"P]
_atbFMexchange+2586  CALLrel  _kkbptsi_pack_tbl_s  4D9C5B4 6BBD3774
r)R oV%v|u#j0                              eg_info+0           
;yUyL)P{/H3M:~0_atbdrv+6333         CALLrel  _atbFMexchange+0     4D9D9EC 4D9D928 4D9D9D8ITPUB个人空间O3kCUgL
                                                   4D9D9E4 6BB99D3C4D9D988ITPUB个人空间;{(pa'q,D7F'XD
HO
                                                   4D9D990 4D9D994
3ht6gbs^ QB bcu0..1.5_1.filter.29+9  CALLrel  _atbdrv+0           ITPUB个人空间'N;D-Z4H+}LZ[
59                                                ITPUB个人空间}&[5B;a.eeN1S
_opiosq0+2487        CALLrel  _opiexe+0            4 0 4D9DDC8ITPUB个人空间(v6y OUV1Z
_kpooprx+236         CALLrel  _opiosq0+0           3 E 4D9DE60 24
H;n/l jG A0p4D0_kpoal8+561          CALLrel  _kpooprx+0           4D9E730 4D9E648 43 1 0 24
:H2fxF c%i%P2^6x|0_opiodr+1244         CALLreg  00000000             5E 14 4D9E72C
8i_6R(L~3E0{J0_ttcpip+2554         CALLreg  00000000             5E 14 4D9E72C0
5K!@-]rWvA$T3W3n_0_opitsk+750          CALLrel  _ttcpip+0           
a.{+xr0vOOL0_opiino+1547         CALLrel  _opitsk+0            0 0 22EED8336F670 D8 0ITPUB个人空间9s-U0I1~gdf)_v
_opiodr+1244         CALLreg  00000000            3C4 4D9FBD4
D$}CP!Ne(g^+c1z0_opidrv+563          CALLrel  _opiodr+0           3C4 4D9FBD4 0
s0}.q5M_-Ww1Z*p0_sou2o+25            CALLrel  _opidrv+0           
;B^%^(YZ
O(p~0_opimai+266          CALLrel  _sou2o+0            ITPUB个人空间[t1vE T7U!w
_OracleThreadStart@  CALLrel  _opimai+0           ITPUB个人空间'Od@0cf:|6k
4+961                                             
&eQ s1B;fhR{ rT07C80B680             CALLreg  00000000            
[7F*P
^8fG9mZ0 
s5wI!W0dgu*c;]!To0--------------------- Binary Stack Dump ---------------------

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