April 1999
Intermediate to advanced
552 pages
15h 39m
English
DBMS_OFFLINE_SNAPSHOT.END_LOAD
Call the END_LOAD procedure after the data import (initiated by the BEGIN_LOAD procedure) is complete. Upon successful completion, the new snapshot is instantiated and operational. The specification is the same for Oracle7 and Oracle8:
PROCEDURE DBMS_OFFLINE_SNAPSHOT.END_LOAD
(gname IN VARCHAR2,
sname IN VARCHAR2,
snapshot_oname IN VARCHAR2);Parameters have the same meanings as for the BEGIN_LOAD procedure. The END_LOAD procedure does not raise any exceptions.
This procedure must be run from the new snapshot site after importing the replicated schema.