Oracle DBMS_OFFLINE_SNAPSHOT
Version 12.1.0.2

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose Public APIs for offline instantiation of snapshots.
AUTHID DEFINER
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_UTL DBMS_SYS_ERROR
DBA_TRIGGERS DBMS_REPCAT_UTL DBMS_SYS_SQL
DBMS_ASSERT DBMS_SNAP_INTERNAL REPCAT$_REPOBJECT
DBMS_INTERNAL_TRIGGER DBMS_SQL REPCAT$_REPSCHEMA
DBMS_REPCAT_DECL DBMS_STANDARD SNAP$
DBMS_REPCAT_SNA    
Documented No
Exceptions
Error Code Reason
ORA-23430 badargument: Bad Argument
ORA-23361 missingremotesnap: Missing Remote Snapshot
ORA-23361 missingremotemview: Missing Remote Materialized View
ORA-23363 snaptabmismatch: Snapshot-Table Mismatch
ORA-23363 mviewtabmismatch: Materialized View Table Mismatch
First Available 1996
Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role
Source {ORACLE_HOME}/rdbms/admin/dbmsofsn.sql
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');

Related Topics
DBMS_MVIEW
DBMS_OFFLINE_UTL
DBMS_REFRESH
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved