qq_36877850
qq_36877850
采纳率0%
2017-01-13 01:31

oracle11g提示ora-604 ora-942

tracr文件信息如下:

Trace file d:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_j000_4004.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.1 Service Pack 1
CPU : 2 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1489M/3283M, Ph+PgF:4449M/6564M, VA:1243M/2047M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 24
Windows thread id: 4004, image: ORACLE.EXE (J000)

*** 2017-01-13 09:21:37.962
*** SESSION ID:(125.4670) 2017-01-13 09:21:37.962
*** CLIENT ID:() 2017-01-13 09:21:37.962
*** SERVICE NAME:(SYS$USERS) 2017-01-13 09:21:37.962
*** MODULE NAME:() 2017-01-13 09:21:37.962
*** ACTION NAME:() 2017-01-13 09:21:37.962

ORA-12012: 自动执行作业 3 出错
ORA-00942: 表或视图不存在

*** 2017-01-13 09:21:37.962
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00942: 表或视图不存在
ORA-12012: 自动执行作业 3 出错
ORA-00942: 表或视图不存在
*** SESSION ID:(125.4672) 2017-01-13 09:21:37.978
*** SERVICE NAME:(SYS$USERS) 2017-01-13 09:21:37.978

*** 2017-01-13 09:21:37.978
ORA-12012: 自动执行作业 26 出错
ORA-00942: 表或视图不存在

*** 2017-01-13 09:21:37.978
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00942: 表或视图不存在
ORA-12012: 自动执行作业 26 出错
ORA-00942: 表或视图不存在
*** SESSION ID:(125.4674) 2017-01-13 09:21:37.993
*** SERVICE NAME:(SYS$USERS) 2017-01-13 09:21:37.993

*** 2017-01-13 09:21:37.993
ORA-12012: error on auto execute of job 4001
ORA-00942: table or view does not exist

*** 2017-01-13 09:21:37.993
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-12012: error on auto execute of job 4001
ORA-00942: table or view does not exist
*** SESSION ID:(125.4676) 2017-01-13 09:21:37.993
*** SERVICE NAME:(SYS$USERS) 2017-01-13 09:21:37.993

*** 2017-01-13 09:21:37.993
ORA-12012: 自动执行作业 29 出错
ORA-00942: 表或视图不存在

*** 2017-01-13 09:21:37.993
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-00942: 表或视图不存在
ORA-12012: 自动执行作业 29 出错
ORA-00942: 表或视图不存在

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

1条回答

  • yunxjun yunxjun 4年前

    怎么出现的这个错误 942已经提示了表或视图不存在

    点赞 评论 复制链接分享

相关推荐