Oracle | DBMS_ISNAPSHOT

Oracle DBMS_ISNAPSHOT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Internal utilities supporting Materialized View Snapshots

AUTHID DEFINER

Dependencies

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

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)

      FROM dual;

      

      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