Name
DBMS_OFFLINE_SNAPSHOT.BEGIN_LOAD
Synopsis
Call the BEGIN_LOAD procedure from the new snapshot site prior to importing the SNA P$table_name tables that were exported from the master site. This call creates empty snapshots and supporting objects. The specifications for the Oracle7 and Oracle8 versions differ as follows.
Oracle7 specification:
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 := '');Oracle8 specification:
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 );The BEGIN_LOAD procedure does not raise any exceptions.
Parameters
Parameter Name | Description |
|---|---|
gname | The replication group to which the new snapshot belongs. |
sname | The schema that owns the new snapshot. |
master_site | The global name of the snapshot master site. |
snapshot_oname | The name of the temporary snapshot created at the master site. |
storage_c | Optional storage clause for the new snapshot. |
comment | Optional comment for the snapshot; stored with entry in DBA_SNAPSHOTS if supplied. |
min_communication (Oracle8 only) | The min_communication parameter controls how the update trigger on updateable snapshot queues changes back to the master site. If this parameter is set to TRUE (the default), then old column values are sent only if ... |