| General Information |
| Purpose |
Public APIs for offline instantiation of snapshots. |
| Source |
{ORACLE_HOME}/rdbms/admin/dbmsofsn.sql |
| First Available |
1996 |
| Constants |
| Name |
Data Type |
Value |
| invalid_user |
PLS_INTEGER |
1 |
| null_input |
PLS_INTEGER |
-1 |
| valid_user |
PLS_INTEGER |
0 |
|
| Dependencies |
| DBA_SNAPSHOTS |
DBMS_REPCAT_SNA |
DBMS_SYS_ERROR |
| DBA_TRIGGERS |
DBMS_REPCAT_SNA_UTL |
DBMS_SYS_SQL |
| DBMS_ASSERT |
DBMS_REPCAT_UTL |
REPCAT$_REPOBJECT |
| DBMS_INTERNAL_TRIGGER |
DBMS_SNAP_INTERNAL |
REPCAT$_REPSCHEMA |
| DBMS_REPCAT_DECL |
DBMS_SQL |
SNAP$ |
|
| Exceptions |
| Number |
Description |
| ORA-23430 |
badargument |
| ORA-23361 |
missingremotesnap |
| ORA-23361 |
missingremotemview |
| ORA-23363 |
snaptabmismatch |
| ORA-23363 |
mviewtabmismatch |
|
| Security Model |
Execute is granted to the EXECUTE_CATALOG_ROLE role |
| Subprograms |
|
| |
| BEGIN_LOAD |
| This routine creates the snapshot named "snapshot_oname" at in schema "snapshot_sname"
that is in object group "gname" |
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); |
| exec dbms_offline_snapshot.begin_load('UWGrp', 'UCLASS', 'UWMaster', 'UWSnap'); |
| |
| END_LOAD |
| Ends the instantiation of the snapshot "snapshot_oname" in schema "sname" of object group "gname" |
dbms_offline_snapshot.end_load(
gname IN VARCHAR2,
sname IN VARCHAR2,
snapshot_oname IN VARCHAR2); |
| exec dbms_offline_snapshot.begin_load('UWGrp', 'UWCLASS', 'UWSnap'); |
