Oracle | DBMS_SNAPSHOT

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	GET_OBJECT_NAME	SYNC_UP_LOG
CLEANUP_SNAPSHOT_IMPORT	GET_PK_BY_EOID	SYNC_UP_LPT
CLEANUP_SUBSCRIPTION	GET_PK_CONSTRAINT_INFO	SYNC_UP_UPD
DIRECT_LOAD_USED	GET_RELATIONAL_COLUMNS	UNREGISTER_SNAPSHOT
DROP_SNAPSHOT	GET_TYPEINFO_BY_TOID	UPDATE_LOG_PLACEHOLDER
GET_EMPTY_SCALARS	IMPORT_LOG_TRIGGER_STRING	VALIDATE
GET_FULLY_QUALIFIED_NAME	IMPORT_LPT_TRIGGER_STRING	VALIDATE_REFRESH
GET_LOB_COLUMNS_INFO	IMPORT_UPD_TRIGGER_STRING	VALIDATE_ROLLBACK_SEGMENT
GET_LOG_AGE	MASTER_LOG_TYPE	VECTOR_COMPARE
GET_LOG_NAME	REGISTER_SNAPSHOT	VERIFY_FC_AGE
GET_LOG_TYPE	SETUP	VERIFY_LOG
GET_MASK_VECTOR	SET_UP	WRAPUP
GET_MAX_BYTES_PER_CHAR	SUBSCRIBE	WRAP_UP
GET_MLOG_FLAG

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

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