ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 作业删除不了 警告文件:ORA-08102: index key not found, obj# 239

作业删除不了 警告文件:ORA-08102: index key not found, obj# 239

原创 Linux操作系统 作者:oraclesvn 时间:2012-04-18 13:31:30 0 删除 编辑
You are trying to manipulate a job in the job queue
(DBA_JOBS/USER_JOBS) and you receive:

ORA-08102: index key not found, object...
     Cause: Internal error: possible inconsistency in index
    Action: Send trace file to your customer support representative, along
            with information on reproducing the error

Example:

SQL> execute dbms_job.remove(1);
ORA-08102: index key not found, object #124 ->>> SYS.I_JOB_NEXT

where object #124 is the object# in DBA_OBJECTS

SQL> column owner format a10
SQL> column object_type format a10
SQL> column object_id format 99999
SQL> column object_name format a10

SQL> select owner, object_name, object_type, object_id
  2  from dba_objects where object_id=124;

OWNER      OBJECT_NAM OBJECT_TYP OBJECT_ID
---------- ---------- ---------- ---------
SYS        I_JOB_NEXT INDEX            124  


Solution Description:
=====================

You need to recreate the inex I_JOB_NEXT.

Script. "$ORACLE_HOME/rdbms/admin/cat7103.sql" creates the I_JOB_NEXT:

Drop and recreate this index.

connect sys/
drop index i_job_next;
create index i_job_next on job$ (next_date)

Note: alter index I_JOB_NEXT rebuild;

      Will not fix the problem.


Explanation:
============

The ORA-8102 pointed to index corruption, so rebuilding the offending index
fixed the problem.
以上摘自:http://www.itpub.net/forum.php?mod=viewthread&tid=1589953&highlight=
 
解决问题:
 
SQL> drop index I_JOB_NEXT;
索引已删除。
SQL> create index I_JOB_NEXT on job$(next_date);
索引已创建。
 
 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26775086/viewspace-721522/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2012-03-25

  • 博文量
    8
  • 访问量
    31112