Oracle DBMS_ISNAPSHOT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx