ORA-00600: internal error code, arguments: [25013] 錯誤處理

SQL>  create tablespace jiujian datafile '/oracle/CRM2/CRM/jiujian.dbf' size 1m;

 create tablespace jiujian datafile '/oracle/CRM2/CRM/jiujian.dbf' size 1m

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [25013], [0], [14], [JIUJIAN], [JIUJIAN], [0], [9], []

SQL>  select file#,status$,ts# from file$;

     FILE#    STATUS$        TS#

---------- ---------- ----------

         1          2          0

         2          2          6

         3          2          2

         4          2          4

         5          2          6

         6          2         13

         7          2          6

         8          2          7

        10          1

         9          1

        11          1

11 rows selected.

注意上面查詢結果file#= 10，9 ，11 因為沒有可關聯的ts#值是以是無效的

SQL> delete from file$ where file#=10;

1 row deleted.

SQL> delete from file$ where file#=9;

SQL> delete from file$ where file#=11;

SQL> commit;

Commit complete.

SQL> select ts#,name,online$ from ts$;

       TS# NAME                                        ONLINE$

---------- ---------------------------------------- ----------

         0 SYSTEM                                            1

         1 UNDOTBS1                                          3

         2 SYSAUX                                            1

         3 TEMP                                              1

         4 USERS                                             1

         5 UNDOTBS2                                          3

         6 ZX                                                1

         7 ZXBIGTBS                                          1

         8 TESTTEMP                                          3

        10 LTEMP1                                            1

         9 TEMPGROUP1                                        1

        11 UNDOTBS3                                          3

        12 TEMPGROUP2                                        3

        13 UNDOTBS4                                          1

        14 JIUJIAN                                           3

15 rows selected.

注意同樣對于ts$ online字段為3的也表示無效的。

SQL> delete from ts$ where ts#=1;

SQL> delete from ts$ where ts#=5;

SQL> delete from ts$ where ts#=11;

SQL> delete from ts$ where ts#=14;

SQL>  select ts#,name,online$ from ts$;

SQL> create tablespace jiujian datafile '/oracle/CRM2/CRM/jiujian.dbf' size 1m;

Tablespace created.

本文轉自 zhangxuwl 51CTO部落格，原文連結：http://blog.51cto.com/jiujian/1059659，如需轉載請自行聯系原作者