ASCP刷快照报错 ORA-27477: "SYS.I…
来源:互联网 发布:宝宝生长曲线图软件 编辑:程序博客网 时间:2024/06/05 10:23
**Starts**25-MAY-2014 17:29:18
ORACLE error 12008 in FDPSTP
Cause: FDPSTP failed due to ORA-12008: error in materialized viewrefresh 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 viewrefresh 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)
- ASCP刷快照报错 ORA-27477: "SYS.I…
- "ORA-01086: savepoint&…
- ORA-14037: 分区 "P8" 的分区界限…
- OERR: ORA-3137 "TTC protocol int…
- 关于SQL SERVER 2005报错"性能监视…
- identifier "tBoolean" is undefie…
- Solution for "Waiting for …
- ORA-00922:missing or i…
- 11g 重建EM 报ORA-20001…
- variable "l" was set but n…
- What is a Perforce "shelved" fil…
- yum groupinstall &quot…
- React-Native "RC…
- yarn上报错Cannot run program "py…
- Xlib: connection to ":0.0" refus…
- SQL Server 2005 "sa"帐号被禁用 …
- Unix/Linux 脚本中 "set -e" 的作…
- ZZULI_SUMMER_PRACTICE(7) 1177 "…
- RAC+Solaris+使用DISM 可能引…
- Caffe: Faster-RCNN Python版本配置 (Windows)
- Opatch报错,OUI-67035,OUI-67073…
- 使用dbms_xplan包查看执行计划
- 深入tornado中的ioLoop
- ASCP刷快照报错 ORA-27477: "SYS.I…
- RandomAccessFile
- RAC 修改字符集 AL32UTF8-->UTF8
- Jquery(二)
- MSCSLD : Error in…
- 可能阻塞接收事务处理器的Module
- 11g回收临时表空间的命令增强
- alter database begin&n…
- Expanded controlfile s…