Creating auto refresh view
Create no refresh view
-
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 view
-
-- 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);
RJM Article Type
Quick Reference