ORA-08103: object no longer exists

一客户在查询数据时报如下错误:

SQL> select count(*) from sa.g_sn_travel;
select count(*) from sa.g_sn_travel
*
ERROR 位于第 1 行:
ORA-08103: object no longer exists

用analyze分析该表,出现如下提示:

SQL> analyze table sa.g_sn_travel validate structure cascade;
analyze table sa.g_sn_travel validate structure cascade
*
ERROR 位于第 1 行:
ORA-01499: table/index cross reference failure - see trace file

查看对应的trace file发现该表的索引和表的数据出现不一致,于是重新创建该Index解决问题。

当然ORA-08103错误还有其他原因,比如:

1.你在查询时,刚好有另外一个用户对该表进行truncate动作也会造成这个错误

2.如果该表有完全刷新的snapshot的话也会造成该错误,因为完全刷新的snapshot也会执行truncate

3.有可能存在坏块

  

1 Comment so far

Leave a comment

Name(required)
Mail (will not be published)(required)
Website

Fields in bold are required. Email addresses are never published or distributed.

Some HTML code is allowed:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>
URLs must be fully qualified (eg: http://www.dbifan.com),and all tags must be properly closed.

Line breaks and paragraphs are automatically converted.

Please keep comments relevant. Off-topic, offensive or inappropriate comments may be edited or removed.

    搜索本站

    站点日历

    9月 2006
    « 8   10 »
     123
    45678910
    11121314151617
    18192021222324
    252627282930  

    订阅本站

    文章分类

    最新日志

    热点文章

    日志存档

    常用标签