December 2002
Intermediate to advanced
928 pages
85h 29m
English
PROCEDURE DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
(gname IN VARCHAR2,
sname IN VARCHAR2,
master_site IN VARCHAR2,
snapshot_oname IN VARCHAR2,
storage_c IN VARCHAR2 := '',
comment IN VARCHAR2 := '',
min_communication IN BOOLEAN := TRUE);
Prepares a materialized view in sname for import of a new materialized view, snapshot_oname. If min_communications is TRUE, the update sends a new value of a column only if the value is modified with an UPDATE statement.
PROCEDURE DBMS_OFFLINE_SNAPSHOT.END_LOAD
(gname IN VARCHAR2,
sname IN VARCHAR2,
snapshot_oname IN VARCHAR2);
Completes offline instantiation of snapshot_oname.