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)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值