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

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26775086/viewspace-721522/