Oracle 12cR2 DBMS_SNAP

Oracle DBMS_SNAP_REPAPI Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.

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;

      /

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