Oracle | DBMS_SNAP

Oracle DBMS_SNAP_REPAPI 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 Materialized View Replication API

AUTHID DEFINER

Data Types TYPE idens .... TYPE numarray .... TYPE raws .... TYPE texts ....

Dependencies

DBMS_REPAPI_LIB	DBMS_STANDARD	PLITBLM
DBMS_SNAPSHOT_UTL

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvtsnps.plb

Subprograms

CONTEXT_GET

CONTEXT_SET

CONTEXT_GET

Undocumented dbms_snap_repapi.context_get( expanded_query OUT dbms_snap_repapi.texts, visible_columns OUT dbms_snap_repapi.texts, idx_sql_ops OUT dbms_snap_repapi.numarr, type_sql_ops OUT dbms_snap_repapi.numarr, sql_ops_out OUT dbms_snap_repapi.texts, ops_to_max_map OUT dbms_snap_repapi.numarr, idx_master_tab OUT dbms_snap_repapi.numarr, master_tables OUT dbms_snap_repapi.idens, idx_pk_columns OUT dbms_snap_repapi.numarr, pk_columns OUT dbms_snap_repapi.texts, idx_bitvectors OUT dbms_snap_repapi.numarr, bitvectors OUT dbms_snap_repapi.raws, idx_columns OUT dbms_snap_repapi.numarr, snapshot_columns OUT dbms_snap_repapi.idens, master_columns OUT dbms_snap_repapi.idens, master_positions OUT dbms_snap_repapi.numarr, column_roles OUT dbms_snap_repapi.numarr,

DECLARE

       eq   dbms_snap_repapi.texts;

       vc   dbms_snap_repapi.texts;

       iso  dbms_snap_repapi.numarr;

       tso  dbms_snap_repapi.numarr;

       soo  dbms_snap_repapi.texts;

       otmm dbms_snap_repapi.numarr;

       imt  dbms_snap_repapi.numarr;

       mt   dbms_snap_repapi.idens;

       ipc  dbms_snap_repapi.numarr;

       pc   dbms_snap_repapi.texts;

       ib   dbms_snap_repapi.numarr;

       bv   dbms_snap_repapi.raws;

       ic   dbms_snap_repapi.numarr;

       sc   dbms_snap_repapi.idens;

       mc   dbms_snap_repapi.idens;

       mp   dbms_snap_repapi.numarr;

       cr   dbms_snap_repapi.numarr; 

      BEGIN

        dbms_snap_repapi.context_get(eq, vc, iso, tso, soo, otmm, imt, mt, ipc, pc, ib, bv, ic, sc, mc, mp, cr);

        dbms_output.put_line(eq.COUNT);

      END;

      /

      0

      

      PL/SQL procedure successfully completed.

CONTEXT_SET

Undocumented dbms_snap_repapi.context_set( definition_query IN VARCHAR2, snapshot_type IN BINARY_INTEGER, refresh_type IN BINARY_INTEGER, snapshot_owner IN VARCHAR2, snapshot_name IN VARCHAR2, generate_ops IN BINARY_INTEGER, flag OUT BINARY_INTEGER, status OUT BINARY_INTEGER, table_cnt OUT BINARY_INTEGER, lob_vector OUT RAW, exp_query_cnt OUT BINARY_INTEGER, vis_col_cnt OUT BINARY_INTEGER, i_sql_ops OUT BINARY_INTEGER, t_sql_ops OUT BINARY_INTEGER, sql_ops_cnt OUT BINARY_INTEGER, ops_map_cnt OUT BINARY_INTEGER, idx_max_tabs_cnt OUT BINARY_INTEGER, master_tables_cnt OUT BINARY_INTEGER, i_pk_columns OUT BINARY_INTEGER, pk_columns_cnt OUT BINARY_INTEGER, idx_bitvecs_cnt OUT BINARY_INTEGER, bitvectors_cnt OUT BINARY_INTEGER, i_column_cnt OUT BINARY_INTEGER, snapshot_col_cnt OUT BINARY_INTEGER, master_col_cnt OUT BINARY_INTEGER, master_pos_cnt OUT BINARY_INTEGER, column_roles_cnt OUT BINARY_INTEGER);

TBD