Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
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);