创建MV

CREATE MATERIALIZED VIEW LOG ON
C_CELL_TEST NOCACHE LOGGING NOPARALLEL WITH PRIMARY KEY;

//建table

CREATE TABLE CMV_C_CELL_TEST
TABLESPACE FMA_DATA
AS
SELECT *
FROM C_CELL_TEST@RPTCL;

ALTER TABLE CMV_C_CELL_TEST ADD CONSTRAINT PK_CMV_C_CELL_TEST PRIMARY KEY (GLASS_ID)
      USING INDEX TABLESPACE FMA_DATA;

//建MV
CREATE MATERIALIZED VIEW CMV_C_CELL_TEST
ON PREBUILT TABLE WITH REDUCED PRECISION
REFRESH FAST ON DEMAND
WITH PRIMARY KEY
FOR UPDATE
AS
SELECT *
FROM C_CELL_TEST@RPTCL;

//启动Job
BEGIN
SYS.DBMS_SCHEDULER.CREATE_JOB
(
 job_name        => 'JOB_CMV_C_CELL_TEST'
,schedule_name   => 'ETL_5_MINUTES'
,job_class       => 'DEFAULT_JOB_CLASS'
,job_type        => 'PLSQL_BLOCK'
,job_action      => 'BEGIN DBMS_SNAPSHOT.REFRESH(LIST => ''CMV_C_CELL_TEST''); END;'
,comments        => NULL
);