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 will be available on generic Linux platforms in January and soon on AIX and Windows

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