Oracle | DBMS_ISNAPSHOT

Oracle DBMS_ISNAPSHOT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal utilities supporting Materialized View Snapshots

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_UTILITY	RGROUP$
DBMS_IREFRESH	DUAL	SLOG$
DBMS_REFRESH	MLOG$	SNAP$
DBMS_SNAPSHOT_KKXRCA	MLOG_REFCOL$	SNAP_COLMAP$
DBMS_SNAPSHOT_LIB	MV_RF$JOBSEQ	SNAP_OBJCOL$
DBMS_SNAPSHOT_UTL	OBJ$	SNAP_REFOP$
DBMS_STANDARD	OLAP_TAB$	SNAP_REFTIME$
DBMS_SYNC_REFRESH_INTERNAL	REG_SNAP$	SNAP_SITE$
DBMS_SYSTEM	RGCHILD$	USER$
DBMS_SYS_ERROR

Documented No

First Available Not Known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsnps.plb

Subprograms

CHANGE_GROUP	DROP_USER_SNAPSHOTS	PURGE_LDR_LOG
CHECK_USRPRIV	FIND_DBLINKS	PURGE_LOG_XID
DROP_GROUP	GET_SCHEDULER_INFORMATION

CHANGE_GROUP

Undocumented dbms_isnapshot.change_group( sow IN VARCHAR2, snapname IN VARCHAR2, mydate IN DATE, mynext IN VARCHAR2, rollseg IN VARCHAR2);

TBD

CHECK_USRPRIV

Validate user privileges

Inputs are not validated dbms_isnapshot.check_usrpriv( tabown IN VARCHAR2, tabnm IN VARCHAR2, priv IN BINARY_INTEGER);

exec dbms_isnapshot.check_usrpriv('UWCLASS', 'SERVERS', 23);

      

      PL/SQL procedure successfully completed.

DROP_GROUP

Drop a snapshot group

Inputs are not validated dbms_isnapshot.drop_group( myuser IN VARCHAR2, myname IN VARCHAR2);

exec dbms_isnapshot.drop_group('UWCLASS', 'SNAPGRP');

      

      PL/SQL procedure successfully completed.

DROP_USER_SNAPSHOTS

Drop snapshots of the identified user

Inputs are not validated dbms_isnapshot.drop_user_snapshots(myuser IN VARCHAR2);

exec dbms_isnapshot.drop_user_snapshots('UWCLASS');

      

      PL/SQL procedure successfully completed.

FIND_DBLINKS

Undocumented but likely finds information related to database links used for materialized view replication dbms_isnapshot.find_dblinks( snaptab IN sys.dbms_utility.uncl_array, cuser IN VARCHAR2, snpcnt IN OUT BINARY_INTEGER, owner IN OUT sys.SYS dbms_utility.name_array, sname IN OUT sys.dbms_utility.name_array, stab IN OUT sys.dbms_utility.name_array, stype IN OUT sys.dbms_utility.number_array, uslog IN OUT sys.dbms_utility.name_array, truemethod IN OUT VARCHAR2, dblink IN OUT sys.dbms_utility.dblink_array, aws IN OUT sys.dbms_utility.number_array);

TBD

GET_SCHEDULER_INFORMATION

Undocumented dbms_isnapshot.get_scheduler_information(ver IN BINARY_INTEGER) RETURN BINARY_INTEGER;

SELECT dbms_isnapshot.get_scheduler_information(21);

      

      DBMS_ISNAPSHOT.GET_SCHEDULER_INFORMATION(21)

      --------------------------------------------

                                                 1

PURGE_LDR_LOG

Purge Loader Log dbms_isnapshot.purge_ldr_log( tableobjnum IN BINARY_INTEGER, purge_options IN BINARY_INTEGER, slg_scn IN NUMBER, slg_odt IN VARCHAR2);

TBD

PURGE_LOG_XID

Purge Transaction Log dbms_isnapshot.purge_log_xid( owner_logname IN VARCHAR2, num IN BINARY_INTEGER, xid IN NUMBER);

TBD