Oracle | DBMS_SNAP

Oracle DBMS_SNAP_REPAPI Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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