DBMS_SNAPSHOT Package

Summary of Subprograms

Table 8-305 DBMS_SNAPSHOT Package Subprograms

Subprogram	Description
BEGIN_TABLE_REORGANIZATION procedure	Performs a process to preserve snapshot data needed for refresh.
END_TABLE_REORGANIZATION procedure procedure	Ensures that the snapshot data for the master table is valid and that the master table is in the proper state.
I_AM_A_REFRESH function	Returns the value of the I_AM_REFRESH package state.
PURGE_DIRECT_LOAD_LOG procedure	Purges rows from the direct loader log after they are no longer needed by any snapshots (used with data warehousing).
PURGE_LOG procedure	Purges rows from the snapshot log.
PURGE_SNAPSHOT_FROM_LOG procedure	Purges rows from the snapshot log.
REFRESH procedure	Consistently refreshes one or more snapshots that are not members of the same refresh group.
REFRESH_ALL_MVIEWS procedure	Refreshes all snapshots that do not reflect changes to their master table.
REFRESH_DEPENDENT procedure	Refreshes all table-based snapshots that depend on a specified master table or list of master tables.
REGISTER_SNAPSHOT procedure	Enables the administration of individual snapshots.
UNREGISTER_SNAPSHOT procedure	Enables the administration of individual snapshots. Invoked at a master site to unregister a snapshot.