2015-05-28 17:15 −场景:跨scheme创建视图,提示ORA-00942 表或视图不存在 1、 创建两个用户 CREATE USER ODI_SRC IDENTIFIED BY ODI_SRC CREATE USER ODI_SRC_WORK IDENTIFIED BY ODI_SRC_WORK 2、 赋予权... 小强斋太 0 2026 ORA-00942:table or view does not exist ...
ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 960 ORA-06512: at line 1 在Oracle的metalink中,一个名为Create Materialized View Results in : Ora-942 [ID 364632.1] 文档是这样解释说它是一个bug。 Symptoms Creating a Materialized view based on a view ...
这时，再用"Select * from QueryHistory"来查询,报 "ORA-00942: 表或视图不存在 " 错误分析:利用Goo...