2 qq 36877850 qq_36877850 于 2017.01.13 09: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   2017.01.13 09:52

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

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!