Oracle DBMS_SNAPSHOT_UTL
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 Utility package supporting snapshot replication.
AUTHID DEFINER
Data Types TYPE dates IS TABLE OF DATE INDEX BY BINARY_INTEGER;

TYPE hashcodes IS TABLE OF VARCHAR2 INDEX BY BINARY_INTEGER;

TYPE idens IS TABLE OF VARCHAR2 INDEX BY BINARY_INTEGER;

TYPE maxvars IS TABLE OF VARCHAR2 INDEX BY BINARY_INTEGER;

TYPE oids IS TABLE OF RAW INDEX BY BINARY_INTEGER;

TYPE scalars IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
Dependencies (Updated to 12.2.0.1)
CCOL$ DBMS_SNAPSHOT DBMS_SYS_SQL
CDEF$ DBMS_SNAPSHOT_KKXRCA DBMS_UTILITY
COL$ DBMS_SNAPSHOT_LIB MLOG$
CON$ DBMS_SNAP_INTERNAL OBJ$
DBA_OBJECTS DBMS_SNAP_REPAPI PLITBLM
DBA_ROLLBACK_SEGS DBMS_SQL REG_SNAP$
DBMS_ASSERT DBMS_STANDARD SNAP$
DBMS_IJOB DBMS_SYSTEM SYN$
DBMS_ISNAPSHOT DBMS_SYS_ERROR USER$
DBMS_LOGREP_UTIL    
Documented No
First Available 8i (1996)
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/prvtsnps.plb
Subprograms
 
CHECK_REFERENTIAL_CONSTRAINT
Undocumented dbms_snapshot_utl.check_referential_constraint(
base_owner   IN  VARCHAR2,
base_name    IN  VARCHAR2,
base_columns IN  VARCHAR2,
col_count    IN  NUMBER,
ref_columns  IN  VARCHAR2,
ref_owner    IN  VARCHAR2,
ref_name     IN  VARCHAR2,
result       OUT NUMBER);
TBD
 
CLEANUP_SNAPSHOT_IMPORT
Undocumented

Overload 1
dbms_snapshot_utl.cleanup_snapshot_import(
sname        IN VARCHAR2,
dump_version IN NUMBER);
TBD
Overload 2 dbms_snapshot_utl.cleanup_snapshot_import(
sname   IN VARCHAR2,
expseal IN VARCHAR2);
TBD
 
CLEANUP_SUBSCRIPTION
Undocumented dbms_snapshot_utl.cleanup_subscription(
hdl   IN  BINARY_INTEGER,
rbseg IN  VARCHAR2,
stat  OUT BINARY_INTEGER);
TBD
 
DIRECT_LOAD_USED
Undocumented dbms_repcat.direct_load_used(
tableobj_col IN  dbms_snapshot_utl.scalars,
lold_col     IN  dbms_snapshot_utl.dates,
rscn_col     IN  dbms_snapshot_utl.scalars,
dlused       OUT BINARY_INTEGER);
TBD
 
DROP_SNAPSHOT
Drops a replication snapshot dbms_snapshot_utl.drop_snapshot(
mowner       IN VARCHAR2,
master       IN VARCHAR2,
snapid       IN BINARY_INTEGER,
rollback_seg IN VARCHAR2);
TBD
 
GET_EMPTY_SCALARS
Empties the "scalar" array by binary integer data type dbms_snapshot_utl.get_empty_scalars RETURN dbms_snapshot_utl.scalars;
DECLARE
 vScalars dbms_snapshot_utl.scalars;
BEGIN
  vScalars(1) := 100;
  vScalars(2) := 200;
  dbms_output.put_line('Before: ' || (vScalars(1) + vScalars(2)));

  vScalars := dbms_snapshot_utl.get_empty_scalars;

  dbms_output.put_line('After: ' || (vScalars(1) + vScalars(2)));
END;
/
Before: 300
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 10
 
GET_FULLY_QUALIFIED_NAME
Undocumented dbms_snapshot_utl.get_fully_qualified_name(
tobjn_col  IN  dbms_snapshot_utl.scalars,
colno_col  IN  dbms_snapshot_utl.scalars,
fqname_col OUT dbms_snapshot_utl.maxvars);
TBD
 
GET_LOB_COLUMNS_INFO
Undocumented dbms_snapshot_utl.get_lob_columns_info(
masown       IN  VARCHAR2,
masnam       IN  VARCHAR2,
snapcols     IN  VARCHAR2,
lobcnt       OUT NUMBER,
lobcols      OUT VARCHAR2,
lobpositions OUT VARCHAR2,
lobvecmask   OUT RAW);
conn sys@pdbdev as sysdba

CREATE MATERIALIZED VIEW pm.mv_lob
TABLESPACE uwdata
REFRESH COMPLETE
START WITH SYSDATE
NEXT SYSDATE + 1 AS
SELECT product_id, ad_photo
FROM pm.print_media;

set serveroutput on

DECLARE
 a NUMBER;
 b VARCHAR2(100);
 c VARCHAR2(100);
 r RAW(32);
BEGIN
  dbms_snapshot_utl.get_lob_columns_info('PM','MV_LOB','PRODUCT_ID',a,b,c,r);
  dbms_output.put_line('LOBCNT: ' || TO_CHAR(a));
  dbms_output.put_line('LOBCOLS: ' || b);
  dbms_output.put_line('LOBPOSITIONS: ' || c);
  dbms_output.put_line('LOBVECMASK: ' || TO_CHAR(r));
END;
/
 
GET_LOG_AGE
Undocumented

The demo does not work but it may help someone figure out what is missing. I've tried lots of permutations based on DML, commits, rollbacks, etc. with the underlying MV to no avail.
dbms_snapshot_utl.get_log_age(
log_age  IN OUT DATE,
mow      IN     VARCHAR2,
mas      IN     VARCHAR2,
snaptype IN     NUMBER);
set serveroutput on

DECLARE
 d DATE := SYSDATE;
BEGIN
  dbms_snapshot_utl.get_log_age(d,'UWCLASS','MV1',1);
  dbms_output.put_line(d);
END;
/
DECLARE
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_SNAPSHOT_UTL", line 1494
ORA-06512: at line 4
 
GET_LOG_NAME
Returns the name and related information about a materialized view log

Overload 1
dbms_snapshot_utl.get_log_name(
master   IN  VARCHAR2,
mowner   IN  VARCHAR2,
lognm    OUT VARCHAR2,
chkflg   IN  BINARY_INTEGER,
status   OUT BINARY_INTEGER,
masobjid OUT BINARY_INTEGER);
CREATE MATERIALIZED VIEW mv1
TABLESPACE uwdata
REFRESH COMPLETE
AS SELECT s.srvr_id, COUNT(*)
FROM servers s, serv_inst i
WHERE s.srvr_id = i.srvr_id
GROUP BY s.srvr_id;

DECLARE
 logName VARCHAR2(30);
 nStatus PLS_INTEGER;
 objID   PLS_INTEGER;
BEGIN
  sys.dbms_snapshot_utl.get_log_name('MV1','UWCLASS', logName, 1, nStatus, objID);

 dbms_output.put_line(logName);
 dbms_output.put_line(nStatus);
 dbms_output.put_line(objID);
END;
/
Overload 2 dbms_snapshot_utl.get_log_name(
sname  IN     VARCHAR2,
sowner IN     VARCHAR2,
lognm  IN OUT VARCHAR2,
chkpk  IN     BINARY_INTEGER,
status    OUT BINARY_INTEGER);
CREATE MATERIALIZED VIEW mv1
TABLESPACE uwdata
REFRESH COMPLETE
AS SELECT s.srvr_id, COUNT(*)
FROM servers s, serv_inst i
WHERE s.srvr_id = i.srvr_id
GROUP BY s.srvr_id;

DECLARE
logName VARCHAR2(30);
nStatus PLS_INTEGER;
BEGIN
  sys.dbms_snapshot_utl.get_log_name('MV1','UWCLASS', logName, 1, nStatus);
  dbms_output.put_line(logName);
  dbms_output.put_line(nStatus);
END;
/
 
GET_LOG_TYPE
Returns the type of materialized viewlog dbms_snapshot_utl.get_log_type(
mowner    IN  VARCHAR2,
master    IN  VARCHAR2,
masobjnum OUT BINARY_INTEGER,
log_type  OUT BINARY_INTEGER);
CREATE MATERIALIZED VIEW mv1
TABLESPACE uwdata
REFRESH COMPLETE
AS SELECT s.srvr_id, COUNT(*)
FROM servers s, serv_inst i
WHERE s.srvr_id = i.srvr_id
GROUP BY s.srvr_id;

set serveroutput on

DECLARE
 objID   PLS_INTEGER;
 objType PLS_INTEGER;
BEGIN
  sys.dbms_snapshot_utl.get_log_type('UWCLASS','MV1', objID, objType);
  dbms_output.put_line(objID);
  dbms_output.put_line(objType);
END;
/
 
GET_MASK_VECTOR
Undocumented dbms_snapshot_utl.get_mask_vector(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2,
column_list IN VARCHAR2)
RETURN RAW;
set serveroutput on

DECLARE
 r RAW(32767);
BEGIN
  r := dbms_snapshot_utl.get_mask_vector('PM','MV_LOB', 'PRODUCT_ID');
  dbms_output.put_line(TO_CHAR(r));
END;
/
 
GET_MAX_BYTES_PER_CHAR
Returns one if the database character set is single-byte. Two or three for multibyte character sets. dbms_snapshot_utl.get_max_bytes_per_char(nbytes OUT BINARY_INTEGER);
set serveroutput on

DECLARE
 bi BINARY_INTEGER;
BEGIN
  dbms_snapshot_utl.get_max_bytes_per_char(bi);
  dbms_output.put_line(TO_CHAR(bi));
END;
/
 
GET_MLOG_FLAG
Undocumented dbms_snapshot_utl.get_mlog_flag(
outflag  IN OUT BINARY_INTEGER,
inmowner IN     VARCHAR2,
intable  IN     VARCHAR2);
TBD
 
GET_OBJECT_NAME
Given an input of an object_id returns the object's owner and name dbms_snapshot_utl.get_object_name(
objn_col  IN  dbms_snapshot_utl.scalars,
owner_col OUT dbms_snapshot_utl.idens,
name_col  OUT dbms_snapshot_utl.idens);
SELECT object_id
FROM dba_objects
WHERE owner = 'PM'
AND object_name = 'MV_LOB';

set serveroutput on

DECLARE
 ob dbms_snapshot_utl.scalars;
 ow dbms_snapshot_utl.idens;
 nc dbms_snapshot_utl.idens;
BEGIN
  ob(1) := 82168;
  ob(2) := 82171;
  dbms_snapshot_utl.get_object_name(ob, ow, nc);
  dbms_output.put_line(ow(1) || ' ' || nc(1));
  dbms_output.put_line(ow(2) || ' ' || nc(2));
END;
/
 
GET_PK_BY_EOID
Undocumented dbms_snapshot_utl.get_pk_by_eoid(
eoid_col      IN  dbms_snapshot_utl.oids,
tobjnum_col   OUT dbms_snapshot_utl.scalars,
tpkct_col     OUT dbms_snapshot_utl.scalars,
tpkintcol_col OUT dbms_snapshot_utl.scalars,
tpkcolnam_col OUT dbms_snapshot_utl.idens,
tpkflg_col    OUT dbms_snapshot_utl.scalars);
TBD
 
GET_PK_CONSTRAINT_INFO
Undocumented dbms_snapshot_utl.get_pk_constraint_info(
owner       IN  VARCHAR2,
tablename   IN  VARCHAR2,
pk_name     IN  VARCHAR2,
pk_type     OUT BINARY_INTEGER,
pk_cols     OUT VARCHAR2,
pk_idx_name OUT VARCHAR2,
idx_cols    OUT VARCHAR2);
TBD
 
GET_RELATIONAL_COLUMNS
Undocumented dbms_snapshot_utl.get_relational_columns(
owner     IN  VARCHAR2,
tablename IN  VARCHAR2,
colname   IN  VARCHAR2,
rcols     OUT dbms_snapshot_utl.idens,
numcols   OUT BINARY_INTEGER);
TBD
 
GET_TYPEINFO_BY_TOID
Undocumented dbms_snapshot_utl.get_typeinfo_by_toid(
typeoid_col   IN  dbms_snapshot_utl.oids,
ownername_col OUT dbms_snapshot_utl.idens,
typename_col  OUT dbms_snapshot_utl.idens,
hashcode_col  OUT dbms_snapshot_utl.hashcodes);
TBD
 
IMPORT_LOG_TRIGGER_STRING
Undocumented dbms_snapshot_utl.import_log_trigger_string(arg IN VARCHAR2) RETURN VARCHAR2;
TBD
 
IMPORT_LPT_TRIGGER_STRING (new 21c)
Undocumented dbms_snapshot_utl.import_lpt_trigger_string(arg IN VARCHAR2) RETURN VARCHAR2;
TBD
 
IMPORT_UPD_TRIGGER_STRING
Undocumented dbms_snapshot_utl.import_upd_trigger_string(arg IN VARCHAR2) RETURN VARCHAR2;
TBD
 
MASTER_LOG_TYPE
Undocumented dbms_snapshot_utl.master_log_type(
mown_col IN  dbms_snapshot_utl.idens,
mas_col  IN  dbms_snapshot_utl.idens,
logt_col OUT dbms_snapshot_utl.scalars);
TBD
 
REGISTER_SNAPSHOT
Undocumented dbms_snapshot_utl.register_snapshot(
snapowner    IN VARCHAR2,
snapname     IN VARCHAR2,
snapsite     IN VARCHAR2,
snapshot_id  IN BINARY_INTEGER,
flag         IN BINARY_INTEGER,
qry_txt      IN VARCHAR2,
rep_type     IN BINARY_INTEGER,
rollback_seg IN VARCHAR2);
TBD
 
SETUP
Undocumented dbms_snapshot_utl.setup(
hdl_col    IN  dbms_snapshot_utl.scalars,
idx_col    IN  dbms_snapshot_utl.scalars,
mown_col   IN  dbms_snapshot_utl.idens,
mas_col    IN  dbms_snapshot_utl.idens,
rbseg_col  IN  dbms_snapshot_utl.idens,
inflag_col IN  dbms_snapshot_utl.scalars,
rcscn      OUT NUMBER);
TBD
 
SET_UP
Undocumented

Overload 1
dbms_snapshot_utl.set_up(
mown_col         IN  dbms_snapshot_utl.idens,
mas_col          IN  dbms_snapshot_utl.idens,
rollseg_col      IN  dbms_snapshot_utl.idens,
flag_col         IN  dbms_snapshot_utl.scalars,
outflag_col      OUT dbms_snapshot_utl.scalars,
snaptime_col     OUT dbms_snapshot_utl.dates,
loadertime_col   OUT dbms_snapshot_utl.dates,
num_sid          IN  BINARY_INTEGER,
snapid_tab       OUT dbms_snapshot_utl.scalars,
max_tab_scn_col  OUT dbms_snapshot_utl.scalars,
max_dl_scn_col   OUT dbms_snapshot_utl.scalars,
max_pmop_scn_col OUT dbms_snapshot_utl.scalars,
trunc_scn_col    OUT dbms_snapshot_utl.scalars,
max_ins_tim_col  OUT dbms_snapshot_utl.dates,
max_upd_tim_col  OUT dbms_snapshot_utl.dates,
max_del_tim_col  OUT dbms_snapshot_utl.dates,
max_ins_scn_col  OUT dbms_snapshot_utl.scalars,
max_upd_tim_col  OUT dbms_snapshot_utl.scalars,
max_del_tim_col  OUT dbms_snapshot_utl.scalars,
hdl_col          IN  dbms_snapshot_utl.scalars,
hdl_idx_col      IN  dbms_snapshot_utl.scalars,
rscn             OUT NUMBER);
TBD
Overload 2 dbms_snapshot_utl.set_up(
mown_col         IN  dbms_snapshot_utl.idens,
mas_col          IN  dbms_snapshot_utl.idens,
masobj_col       IN  dbms_snapshot_utl.scalars,
rollseg_col      IN  dbms_snapshot_utl.idens,
flag_col         IN  dbms_snapshot_utl.scalars,
snaptime_col     OUT dbms_snapshot_utl.dates,
loadertime_col   OUT dbms_snapshot_utl.dates,
num_sid          IN  BINARY_INTEGER,
snapid_tab       OUT dbms_snapshot_utl.scalars);
TBD
Overload 3 dbms_snapshot_utl.set_up(
mown_col       IN  dbms_snapshot_utl.idens,
mas_col        IN  dbms_snapshot_utl.idens,
masobj_col     IN  dbms_snapshot_utl.scalars,
rollseg_col    IN  dbms_snapshot_utl.idens,
flag_col       IN  dbms_snapshot_utl.scalars,
snaptime_col   OUT dbms_snapshot_utl.dates,
loadertime_col OUT dbms_snapshot_utl.dates,
num_sid        IN  BINARY_INTEGER,
snapid_tab     OUT dbms_snapshot_utl.scalars,
su_scn_col     OUT dbms_snapshot_utl.scalars,
nr_flag        IN  BINARY_INTEGER);
TBD
Overload 4 dbms_snapshot_utl.set_up(
mowner       IN     VARCHAR2,
master       IN     VARCHAR2,
log          IN OUT VARCHAR2,
snapid       IN OUT BINARY_INTEGER,
snaptime     IN OUT DATE,
snaptype     IN     BINARY_INTEGER,
rollback_seg IN     VARCHAR2);
TBD
Overload 5 dbms_snapshot_utl.set_up(
mowner       IN     VARCHAR2,
master       IN     VARCHAR2,
masobjnum    IN     BINARY_INTEGER,
log          IN OUT VARCHAR2,
snapid       IN OUT BINARY_INTEGER,
snaptime     IN OUT DATE,
snaptype     IN     BINARY_INTEGER,
rollback_seg IN     VARCHAR2);
TBD
 
SUBSCRIBE
Undocumented dbms_snapshot_utl.subscribe(
cset   IN     VARCHAR2,
mown   IN     VARCHAR2,
mas    IN     VARCHAR2,
mvflg  IN     BINARY_INTEGER,
scvect IN     RAW,
act    IN     BINARY_INTEGER,
lrscn  IN     NUMBER,
hdl    IN OUT BINARY_INTEGER,
cvnam     OUT VARCHAR2,
stat      OUT BINARY_INTEGER);
TBD
 
SYNC_UP_LOG
Undocumented dbms_snapshot_utl.sync_up_log(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
TBD
 
SYNC_UP_LPT (new 21c)
Undocumented dbms_snapshot_utl.import_lpt_trigger_string(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
TBD
 
SYNC_UP_UPD
Undocumented dbms_snapshot_utl.sync_up_upd(
canon_sname IN VARCHAR2,
canon_oname IN VARCHAR2);
TBD
 
UNREGISTER_SNAPSHOT
Undocumented dbms_snapshot_utl.unregister_snapshot(
snapowner    IN VARCHAR2,
snapname     IN VARCHAR2,
snapsite     IN VARCHAR2,
rollback_seg IN VARCHAR2);
TBD
 
UPDATE_LOG_PLACEHOLDER
Undocumented dbms_snapshot_utl.update_log_placeholder(
mown_col    IN     dbms_snapshot_utl.idens,
mas_col     IN     dbms_snapshot_utl.idens,
rollseg     IN     VARCHAR2,
snapid      IN OUT BINARY_INTEGER,
snaptype    IN     BINARY_INTEGER,
ll_update   IN OUT BINARY_INTEGER,
sl_update   IN OUT BINARY_INTEGER,
oper        IN     BINARY_INTEGER,
m82_version IN     BINARY_INTEGER);
TBD
 
VALIDATE
Undocumented dbms_snapshot_utl.validate(
hdl_col   IN dbms_snapshot_utl.scalars,
idx_col   IN dbms_snapshot_utl.scalars,
mown_col  IN dbms_snapshot_utl.idens,
mas_col   IN dbms_snapshot_utl.idens,
lrscn_col IN dbms_snapshot_utl.scalars,
stat_col  IN dbms_snapshot_utl.scalars);
TBD
 
VALIDATE_REFRESH
Undocumented dbms_snapshot_utl.validate_refresh(
mowner     IN VARCHAR2,
master     IN VARCHAR2,
snaptype   IN BINARY_INTEGER,
check_cols IN VARCHAR2);
TBD
 
VALIDATE_ROLLBACK_SEGMENT
Appears to return 1 if a rollback or undo segment is valid dbms_snapshot_utl.validate_rollback_segment(
segment_name   IN  VARCHAR2,
segment_status OUT BINARY_INTEGER);
SELECT segment_name
FROM dba_rollback_segs;

set serveroutput on

DECLARE
 vStatus BINARY_INTEGER;
BEGIN
  dbms_snapshot_utl.validate_rollback_segment('SYSTEM', vStatus);
  dbms_output.put_line(vStatus);

  dbms_snapshot_utl.validate_rollback_segment('_SYSSMU2_1606812849$', vStatus);
  dbms_output.put_line(vStatus);
END;
/
 
VECTOR_COMPARE
Undocumented dbms_snapshot_utl.vector_compare(
vec1 IN RAW,
vec2 IN RAW)
RETURN BINARY_INTEGER;
TBD
 
VERIFY_FC_AGE
Undocumented dbms_snapshot_utl.verify_fc_age(
mowner   IN  VARCHAR2,
master   IN  VARCHAR2,
fc_vec   IN  RAW,
snaptime IN  DATE,
flag     OUT BINARY_INTEGER);
TBD
 
VERIFY_LOG
Undocumented

Overload 1
dbms_snapshot_utl.verify_log(
mown_col        IN  dbms_snapshot_utl.idens,
mas_col         IN  dbms_snapshot_utl.idens,
masobj_col      OUT dbms_snapshot_utl.scalars,
flag_col        IN  dbms_snapshot_utl.scalars,
outflag_col     OUT dbms_snapshot_utl.scalars,
logmn_col       OUT dbms_snapshot_utl.idens,
oldest_col      OUT dbms_snapshot_utl.dates,
oldestpk_col    OUT dbms_snapshot_utl.dates,
oldloader_col   OUT dbms_snapshot_utl.dates,
oldest_oid_col  OUT dbms_snapshot_utl.dates,
oldestnew_col   OUT dbms_snapshot_utl.dates,
fcvec_col       OUT dbms_snapshot_utl.raws,
youngest_fc_col OUT dbms_snapshot_utl.dates,
hdl_col         IN  dbms_snapshot_utl.scalars,
hdl_indx_col    IN  dbms_snapshot_utl.scalars,
lrscn_col       IN  dbms_snapshot_utl.scalars,
stat_col        OUT dbms_snapshot_utl.scalars,
typ_own_col     IN  dbms_snapshot_utl.idens,
typ_nam_col     IN  dbms_snapshot_utl.idens,
toid_col        OUT dbms_snapshot_utl.oids,
hashcode_col    OUT dbms_snapshot_utl.hashcodes);
TBD
Overload 2 dbms_snapshot_utl.verify_log(
mown_col        IN  dbms_snapshot_utl.idens,
mas_col         IN  dbms_snapshot_utl.idens,
masobj_col      OUT dbms_snapshot_utl.scalars,
flag_col        IN  dbms_snapshot_utl.scalars,
outflag_col     OUT dbms_snapshot_utl.scalars,
logmn_col       OUT dbms_snapshot_utl.idens,
oldest_col      OUT dbms_snapshot_utl.dates,
oldestpk_col    OUT dbms_snapshot_utl.dates,
oldloader_col   OUT dbms_snapshot_utl.dates,
oldest_oid_col  OUT dbms_snapshot_utl.dates,
oldestnew_col   OUT dbms_snapshot_utl.dates,
fcvec_col       OUT dbms_snapshot_utl.raws,
youngest_fc_col OUT dbms_snapshot_utl.dates,
hdl_col         IN  dbms_snapshot_utl.scalars,
hdl_indx_col    IN  dbms_snapshot_utl.scalars,
lrscn_col       IN  dbms_snapshot_utl.scalars,
stat_col        OUT dbms_snapshot_utl.scalars,
typ_own_col     IN  dbms_snapshot_utl.idens,
typ_nam_col     IN  dbms_snapshot_utl.idens,
toid_col        OUT dbms_snapshot_utl.oids,
hashcode_col    OUT dbms_snapshot_utl.hashcodes,
oldestseq_col   OUT dbms_snapshot_utl.dates);
TBD
Overload 3 dbms_snapshot_utl.verify_log(
mown_col        IN  dbms_snapshot_utl.idens,
mas_col         IN  dbms_snapshot_utl.idens,
masobj_col      OUT dbms_snapshot_utl.scalars,
flag_col        IN  dbms_snapshot_utl.scalars,
outflag_col     OUT dbms_snapshot_utl.scalars,
logmn_col       OUT dbms_snapshot_utl.idens,
oldest_col      OUT dbms_snapshot_utl.dates,
oldestpk_col    OUT dbms_snapshot_utl.dates,
oldloader_col   OUT dbms_snapshot_utl.dates,
oldest_oid_col  OUT dbms_snapshot_utl.dates,
oldestnew_col   OUT dbms_snapshot_utl.dates,
fcvec_col       OUT dbms_snapshot_utl.raws,
youngest_fc_col OUT dbms_snapshot_utl.dates,
hdl_col         IN  dbms_snapshot_utl.scalars,
hdl_indx_col    IN  dbms_snapshot_utl.scalars,
lrscn_col       IN  dbms_snapshot_utl.scalars,
stat_col        OUT dbms_snapshot_utl.scalars,
typ_own_col     IN  dbms_snapshot_utl.idens,
typ_nam_col     IN  dbms_snapshot_utl.idens,
toid_col        OUT dbms_snapshot_utl.oids,
hashcode_col    OUT dbms_snapshot_utl.hashcodes,
oldestseq_col   OUT dbms_snapshot_utl.dates,
nr_flag         IN  BINARY_INTEGER);
TBD
Overload 4 dbms_snapshot_utl.verify_log(
mown_col        IN  dbms_snapshot_utl.idens,
mas_col         IN  dbms_snapshot_utl.idens,
masobj_col      IN  dbms_snapshot_utl.scalars,
flag_col        IN  dbms_snapshot_utl.scalars,
outflag_col     OUT dbms_snapshot_utl.scalars,
logmn_col       OUT dbms_snapshot_utl.idens,
oldest_col      OUT dbms_snapshot_utl.dates,
oldestpk_col    OUT dbms_snapshot_utl.dates,
oldloader_col   OUT dbms_snapshot_utl.dates,
fcvec_col       OUT dbms_snapshot_utl.raws,
youngest_fc_col OUT dbms_snapshot_utl.dates,
mod_scn_col     OUT dbms_snapshot_utl.scalars,
nr_flag         IN  BINARY_INTEGER);
TBD
Overload 5 dbms_snapshot_utl.verify_log(
mow     IN     VARCHAR2,
mas     IN     VARCHAR2,
stime   IN     DATE,
stype   IN     NUMBER,
fcvec   IN     RAW,
eqcvec  IN     RAW,
in_vec  IN     BINARY_INTEGER,
out_rec IN OUT BINARY_INTEGER);
TBD
 
WRAPUP
Undocumented dbms_snapshot_utl.wrapup(
hdl_col   IN dbms_snapshot_utl.scalars,
rbseg_col IN dbms_snapshot_utl.idens);
TBD
 
WRAP_UP
Undocumented

Overload 1
dbms_snapshot_utl.wrap_up(
mown_col       IN dbms_snapshot_utl.idens,
mas_col        IN dbms_snapshot_utl.idens,
masobj_col     IN dbms_snapshot_utl.scalars,
rollseg_col    IN dbms_snapshot_utl.idens,
flag_col       IN dbms_snapshot_utl.scalars,
snaptime_col   IN dbms_snapshot_utl.dates,
loadertime_col IN dbms_snapshot_utl.dates,
snapid_col     IN dbms_snapshot_utl.scalars,
snaptype_col   IN dbms_snapshot_utl.scalars,
masidx_col     IN dbms_snapshot_utl.scalars,
rscn           IN NUMBER,
mastype_col    IN dbms_snapshot_utl.scalars);
TBD
Overload 2 dbms_snapshot_utl.wrap_up(
snapid_col     IN dbms_snapshot_utl.scalars,
snaptype_col   IN dbms_snapshot_utl.scalars,
masidx_col     IN dbms_snapshot_utl.scalars,
mown_col       IN dbms_snapshot_utl.idens,
mas_col        IN dbms_snapshot_utl.idens,
masobj_col     IN dbms_snapshot_utl.scalars,
rollseg_col    IN dbms_snapshot_utl.idens,
flag_col       IN dbms_snapshot_utl.scalars,
snaptime_col   IN dbms_snapshot_utl.dates,
loadertime_col IN dbms_snapshot_utl.dates);
TBD
Overload 3 dbms_snapshot_utl.wrap_up(
mowner              IN  VARCHAR2,
master              IN  VARCHAR2,
snapid              IN  BINARY_INTEGER,
snaptime            IN  DATE,
registration_status OUT BINARY_INTEGER,
snaptype            IN  BINARY_INTEGER,
rollback_seg        IN  VARCHAR2);
TBD
Overload 4 dbms_snapshot_utl.wrap_up(
mowner              IN  VARCHAR2,
master              IN  VARCHAR2,
masobjnum           IN  BINARY_INTEGER,
snapid              IN  BINARY_INTEGER,
snaptime            IN  DATE,
loadertime          IN  DATE,
registration_status OUT BINARY_INTEGER,
snaptype            IN  BINARY_INTEGER,
rollback_seg        IN  VARCHAR2);
TBD

Related Topics
Advanced Replication
Built-in Functions
Built-in Packages
DBMS_MVIEW
DBMS_MVIEW_STATS
DBMS_MVIEW_STATS_INTERNAL
DBMS_REFRESH
DBMS_REPCAT
DBMS_REPCAT_MIG
DBMS_REPUTIL
DBMS_SNAPSHOT
DBMS_SNAPSHOT_COMMON
DBMS_SNAPSHOT_KKXRCA
DBMS_SNAP_INTERNAL
DBMS_SNAP_REPAPI
DBMS_XRWMV
Materialized Views
What's New In 21c
What's New In 23c

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