ORA-00600: internal error code, arguments: [25013] 错误处理-阿里云开发者社区

开发者社区> 数据库> 正文
登录阅读全文

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;
1 row deleted.
SQL> delete from file$ where file#=11;
1 row deleted.
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
       TS# NAME                                        ONLINE$
---------- ---------------------------------------- ----------
        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;
1 row deleted.
SQL> delete from ts$ where ts#=5;
1 row deleted.
SQL> delete from ts$ where ts#=11;
1 row deleted.
SQL> delete from ts$ where ts#=14;
1 row deleted.
SQL> commit;
Commit complete.
SQL>  select ts#,name,online$ from ts$;
       TS# NAME                                        ONLINE$
---------- ---------------------------------------- ----------
         0 SYSTEM                                            1
         2 SYSAUX                                            1
         3 TEMP                                              1
         4 USERS                                             1
         6 ZX                                                1
         7 ZXBIGTBS                                          1
         8 TESTTEMP                                          3
        10 LTEMP1                                            1
         9 TEMPGROUP1                                        1
        12 TEMPGROUP2                                        3
        13 UNDOTBS4                                          1
11 rows selected.
SQL> create tablespace jiujian datafile '/oracle/CRM2/CRM/jiujian.dbf' size 1m;
Tablespace created.









本文转自 zhangxuwl 51CTO博客,原文链接:http://blog.51cto.com/jiujian/1059659,如需转载请自行联系原作者

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章
最新文章
相关文章