为了共享本地数据但是又不想把自己本地数据库其他信息给第三方,可以在其他库创建物化视图共享数据,废话不多说,直接上案例
CREATE MATERIALIZED VIEW JQMSRPT.MV_DEMO_TEST
(
"ID",---这里字段要加双引号
/* 表字段*/
)
TABLESPACE BASE_DATA
PCTUSED 0
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOCACHE
NOLOGGING
NOCOMPRESS
BUILD IMMEDIATE
USING INDEX
TABLESPACE BASE_DATA
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
REFRESH FAST ON DEMAND
WITH primary key
AS
/* Formatted on 2022/5/19 9:45:43 (QP5 v5.362) */
SELECT
ID---这里字段不需要加双引号
/* 表字段*/
FROM JQMS.DEMO_TEST@JCET
WHERE DEL_FLAG = '0';
COMMENT ON MATERIALIZED VIEW JQMSRPT.MV_DEMO_TEST IS 'snapshot table for snapshot JQMS.DEMO_TEST';