/u01/app/oracle/admin/SFHIS/bdump/sfhis_1212.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0
System name: Linux
Node name: HISDB
Release: 2.6.9-55.EL
Version: #1 SMP Fri Apr 20 16:33:09 EDT 2007
Machine: ppc64
Instance name: BBBB
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 21860, image: oracle@BBBB (J004)*** ACTION NAME:(JOB_AAA) 2009-11-24 17:05:19.960
*** MODULE NAME:(DBMS_SCHEDULER) 2009-11-24 17:05:19.960
*** SERVICE NAME:(SYS$USERS) 2009-11-24 17:05:19.960
*** CLIENT ID:() 2009-11-24 17:05:19.960
*** SESSION ID:(500.34132) 2009-11-24 17:05:19.960
*** 2009-11-24 17:05:19.960
ORA-12012: error on auto execute of job 72969
ORA-12008: error in materialized view refresh path
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0
System name: Linux
Node name: HISDB
Release: 2.6.9-55.EL
Version: #1 SMP Fri Apr 20 16:33:09 EDT 2007
Machine: ppc64
Instance name: BBBB
Redo thread mounted by this instance: 1
Oracle process number: 22
Unix process pid: 21860, image: oracle@BBBB (J004)*** ACTION NAME:(JOB_AAA) 2009-11-24 17:05:19.960
*** MODULE NAME:(DBMS_SCHEDULER) 2009-11-24 17:05:19.960
*** SERVICE NAME:(SYS$USERS) 2009-11-24 17:05:19.960
*** CLIENT ID:() 2009-11-24 17:05:19.960
*** SESSION ID:(500.34132) 2009-11-24 17:05:19.960
*** 2009-11-24 17:05:19.960
ORA-12012: error on auto execute of job 72969
ORA-12008: error in materialized view refresh path
解决方案 »
- Oracle高手进啊
- 请各位分享一下访问Oracle数据库的效率及方法~
- split partition 用法
- 高分请教与探讨,关于long和long raw移植的问题...
- data guard配置过程中ORA-01041: 内部错误,hostdef 扩展名不存在的问题
- [求助]有关在sql中判断查询的问题
- 新手 :一个触发器里游标问题,请各位高手年看看啊
- oracle中。把格式如yyyy-mm-dd的字符串转化为日期型的函数是什么?
- 安装OWB时出错,提示"加载数据库出错:AreaQueries",该如何解决????紧急求救,并献上100分.
- win8.1 系统运行plsql 好多软件直接假死。
- 求个SQL语句,不知道怎么写
- 关于oracle 运行
ORA-12008: error in materialized view refresh path
Cause: Table SNAP$_<mview_name> reads rows from the view MVIEW$_<mview_name>, which is a view on the master table (the master may be at a remote site). Any error in this path will cause this error at refresh time. For fast refreshes, the table <master_owner>.MLOG$_<master> is also referenced.
Action: Examine the other messages on the stack to find the problem. See if the objects SNAP$_<mview_name>, MVIEW$_<mview_name>, <mowner>.<master>@<dblink>, <mowner>.MLOG$_<master>@<dblink> still exist.
ORA-12008: error in materialized view refresh path物化视图刷新错误,检查你的物化视图。
-------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
QQ 群:62697716