为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。 【DM版本】:8 【操作系统】：centos 【CPU】:8 【问题描述】*：物化视图创建后ddl获取不到
可以使用系统包获取物化视图的DDL
–创建表 CREATE TABLE “SYSDBA”.“USERS1” ( “ID” INT NOT NULL, “USERNAME” VARCHAR(255) DEFAULT NULL, “AGE” BIGINT DEFAULT NULL, NOT CLUSTER PRIMARY KEY(“ID”)) STORAGE(ON “MAIN”, CLUSTERBTR) ;
–创建物化视图 CREATE MATERIALIZED VIEW MV_VENDOR_EXCELLENT REFRESH WITH ROWID START WITH SYSDATE NEXT SYSDATE + 1 AS SELECT * from USERS1;
–查询物化视图DDL SELECT dbms_metadata.get_ddl(‘MATERIALIZED_VIEW’,‘MV_VENDOR_EXCELLENT’,‘SYSDBA’);
可以使用系统包获取物化视图的DDL
–创建表
CREATE TABLE “SYSDBA”.“USERS1”
(
“ID” INT NOT NULL,
“USERNAME” VARCHAR(255) DEFAULT NULL,
“AGE” BIGINT DEFAULT NULL,
NOT CLUSTER PRIMARY KEY(“ID”)) STORAGE(ON “MAIN”, CLUSTERBTR) ;
–创建物化视图
CREATE MATERIALIZED VIEW MV_VENDOR_EXCELLENT
REFRESH WITH ROWID START WITH SYSDATE NEXT SYSDATE + 1 AS
SELECT * from USERS1;
–查询物化视图DDL
SELECT dbms_metadata.get_ddl(‘MATERIALIZED_VIEW’,‘MV_VENDOR_EXCELLENT’,‘SYSDBA’);