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
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

Related Topics
Built-in Functions
Built-in Packages
DBMS_MVIEW
DBMS_MVIEW_STATS
DBMS_MVIEW_STATS_INTERNAL
DBMS_REFRESH
DBMS_SNAPSHOT_UTL
Materialized Views
What's New In 12cR1
What's New In 12cR2

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