我们可以在oracle中使用强制和可编辑选项从视图创建Materialized视图吗

Question

我是oracle的新手。我使用的是oracle数据库19c。我试图从一个视图创建一个物化视图。但我得到了"；ORA-00942"；错误这是否意味着mview不能从可强制编辑的视图创建，或者可以使用任何额外的权限创建？提前谢谢。

sql>conn kish/password
Connected.
sql>create table ds as select * from dba_source;
Table created.
sql>create or replace force editionable view "dsv" as select * from ds;
View created.
sql>create materialized view dsmv as select * from dsv;
create materialized view dsmv as select * from dsv
*
ERROR at line 1:
ORA-00942: table or view does not exist

Answer 1

"dsv"与dsv不同。在Oracle中，从不使用双引号(除非您有非常非常好的理由——而这不是一个(。

完全去掉双引号。

SQL> create view dsv as select * from dept;
View created.
SQL> create materialized view dsmv as select * from dsv;
Materialized view created.
SQL> select * from dsmv;
DEPTNO DNAME          LOC
---------- -------------- -------------
10 ACCOUNTING     NEW YORK
20 RESEARCH       DALLAS
30 SALES          CHICAGO
40 OPERATIONS     BOSTON
SQL>