Materialized view Notes

DROP MATERIALIZED VIEW APPS.XXGC_AUDIT_PERSON_MV;

CREATE MATERIALIZED VIEW APPS.XXGC_AUDIT_PERSON_MV

TABLESPACE APPS_TS_TX_DATA

PCTUSED    0

PCTFREE    10

INITRANS   2

MAXTRANS   255

STORAGE    (

            INITIAL          128K

            NEXT             128K

            MINEXTENTS       1

            MAXEXTENTS       UNLIMITED

            PCTINCREASE      0

            BUFFER_POOL      DEFAULT

           )

NOCACHE

LOGGING

NOCOMPRESS

NOPARALLEL

BUILD IMMEDIATE

REFRESH FORCE ON DEMAND

WITH PRIMARY KEY

AS

SELECT *

FROM apps.xxgc_audit_person_v;

 

COMMENT ON MATERIALIZED VIEW APPS.XXGC_AUDIT_PERSON_MV IS 'snapshot table for snapshot APPS.XXGC_AUDIT_PERSON_MV';

   -- Refresh the Materialized view

   logf('About to refresh ' || gc_emp_mview);

   execute immediate 'begin dbms_mview.refresh('''||gc_emp_mview||'''); end;';

   --logf('WARNING REMMED OUT TABLE REFRESH ' || gc_emp_mview);

   logf('After refresh ' || gc_emp_mview);