ASCP刷快照报错 ORA-27477: "SYS.I…

**Starts**25-MAY-2014 17:29:18
ORACLE error 12008 in FDPSTP

Cause: FDPSTP failed due to ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh path
ORA-27477: "SYS.IDX_RB$CLASS_1580" already exists
ORA-06512: at "APPS.MRP_CL_REFRESH_SNAPSHOT",
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
25-MAY 17:29:18 : Database Version: 11.2.0.3.0
25-MAY 17:29:18 : Successfully Truncated the Snapshot Log on Table: WSM_COPY_OPERATIONS
25-MAY 17:39:25 : Error in refresh snapshot program : ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh path
ORA-27477: "SYS.IDX_RB$CLASS_1580" already exists

25-MAY 17:39:25 : Error refreshing individual snapshot : APPS.WSM_LJ_OPRS_SN
25-MAY 17:39:25 : Error : ORA-12008: error in materialized view refresh path
ORA-12008: error in materialized view refresh path
ORA-27477: "SYS.IDX_RB$CLASS_1580" already exists
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 25-MAY-2014 17:39:25

+---------------------------------------------------------------------------+

 

解决：

 

SELECT max(to_number(replace(job_class_name, 'IDX_RB$CLASS_', null)))
FROM dba_scheduler_job_classes
WHERE job_class_name like 'IDX_RB$CLASS_%';

SELECT sys.idx_rb$jobseq.nextval
FROM dual;

select 26532-1581 from dual

 

 

SQL> ALTER SEQUENCE sys.idx_rb$jobseq INCREMENT BY 24951;

Sequence altered.

SQL> ALTER SEQUENCE sys.idx_rb$jobseq INCREMENT BY 1;

Sequence altered.

SQL>
参考文档：Materialiazed View Refresh Fails with ORA-27477: "SYS.IDX_RB$CLASS_" already exists (Doc ID 1496393.1)