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.
logmnr_dict_cache.add_col(
lm_logmnr_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_objv# IN NUMBER,
lm_segcol# IN NUMBER,
lm_intcol# IN NUMBER,
lm_col# IN NUMBER,
lm_colname IN VARCHAR2,
lm_type# IN NUMBER,
lm_length IN NUMBER,
lm_precision IN NUMBER,
lm_scale IN NUMBER,
lm_intervalleadingprecision IN NUMBER,
lm_intervaltrailingprecision IN NUMBER,
lm_property IN NUMBER,
lm_toid IN RAW,
lm_charsetid IN NUMBER,
lm_charsetform IN NUMBER,
lm_typename IN VARCHAR2,
lm_fqcolname IN VARCHAR2,
lm_numintcols IN NUMBER,
lm_numattrs IN NUMBER,
lm_adtorder IN NUMBER,
lm_xtypeschemaname IN VARCHAR2,
lm_xtypename IN VARCHAR2,
lm_xfqcolname IN VARCHAR2,
lm_xtopintcol IN NUMBER,
lm_xreffedtableobjn IN NUMBER,
lm_xreffedtableobjv IN NUMBER,
lm_xcoltypeflags IN NUMBER,
lm_xopqtypetype IN NUMBER,
lm_xopqtypeflags IN NUMBER,
lm_xopqlobintcol IN NUMBER,
lm_xopqobjintcol IN NUMBER,
lm_xxmlintcol IN NUMBER,
lm_eaowner# IN NUMBER,
lm_eamkeyid IN VARCHAR2,
lm_eaencalg IN NUMBER,
lm_eaintalg IN NUMBER,
lm_eacolklc IN RAW,
lm_eaklclen IN NUMBER,
lm_eaflags IN NUMBER,
lm_logmnrderivedflags IN NUMBER,
lm_collid IN NUMBER,
lm_collintcol# IN NUMBER,
lm_acdrrescol# IN NUMBER,
lm_update IN NUMBER);
logmnr_dict_cache.add_obj(
lm_logmnr_uid IN NUMBER,
lm_keyobj# IN NUMBER,
lm_lvlcnt IN NUMBER,
lm_baseobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_lvl1obj# IN NUMBER,
lm_lvl2obj# IN NUMBER,
lm_lvl0type# IN NUMBER,
lm_lvl1type# IN NUMBER,
lm_lvl2type# IN NUMBER,
lm_owner# IN NUMBER,
lm_ownername IN VARCHAR2,
lm_lvl0name IN VARCHAR2,
lm_lvl1name IN VARCHAR2,
lm_lvl2name IN VARCHAR2,
lm_assoc# IN NUMBER,
lm_cols IN NUMBER,
lm_intcols IN NUMBER,
lm_kernelcols IN NUMBER,
lm_tabflags IN NUMBER,
lm_trigflag IN NUMBER,
lm_objflags IN NUMBER,
lm_ts# IN NUMBER,
lm_tsname IN VARCHAR2,
lm_property IN NUMBER,
lm_start_scn IN NUMBER,
lm_drop_scn IN NUMBER,
lm_xidusn IN NUMBER,
lm_xidslt IN NUMBER,
lm_xidsqn IN NUMBER,
lm_flags IN NUMBER,
lm_update IN NUMBER,
lm_unsupportedcols IN NUMBER,
lm_logmnrmcv IN VARCHAR2,
lm_complextypecols IN NUMBER,
lm_ntparentobjnum IN NUMBER,
lm_ntparentobjversion IN NUMBER,
lm_ntparentintcolnum IN NUMBER,
lm_logmnrtloflags IN NUMBER,
lm_parttype IN NUMBER,
lm_subparttype IN NUMBER,
lm_acdrflags IN NUMBER,
lm_acdrtsobj# IN NUMBER,
lm_acdrrowtsintcol# IN NUMBER);
logmnr_dict_cache.add_obj_at(
lm_logmnr_uid IN NUMBER,
lm_keyobj# IN NUMBER,
lm_lvlcnt IN NUMBER,
lm_baseobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_lvl1obj# IN NUMBER,
lm_lvl2obj# IN NUMBER,
lm_lvl0type# IN NUMBER,
lm_lvl1type# IN NUMBER,
lm_lvl2type# IN NUMBER,
lm_owner# IN NUMBER,
lm_ownername IN VARCHAR2,
lm_lvl0name IN VARCHAR2,
lm_lvl1name IN VARCHAR2,
lm_lvl2name IN VARCHAR2,
lm_assoc# IN NUMBER,
lm_cols IN NUMBER,
lm_intcols IN NUMBER,
lm_kernelcols IN NUMBER,
lm_tabflags IN NUMBER,
lm_trigflag IN NUMBER,
lm_objflags IN NUMBER,
lm_ts# IN NUMBER,
lm_tsname IN VARCHAR2,
lm_property IN NUMBER,
lm_start_scn IN NUMBER,
lm_drop_scn IN NUMBER,
lm_xidusn IN NUMBER,
lm_xidslt IN NUMBER,
lm_xidsqn IN NUMBER,
lm_flags IN NUMBER,
lm_update IN NUMBER,
lm_unsupportedcols IN NUMBER,
lm_logmnrmcv IN VARCHAR2,
lm_complextypecols IN NUMBER,
lm_ntparentobjnum IN NUMBER,
lm_ntparentobjversion IN NUMBER,
lm_ntparentintcolnum IN NUMBER,
lm_logmnrtloflags IN NUMBER,
lm_parttype IN NUMBER,
lm_subparttype IN NUMBER,
lm_acdrflags IN NUMBER,
lm_acdrtsobj# IN NUMBER,
lm_acdrrowtsintcol# IN NUMBER);
logmnr_dict_cache.add_sba(
lm_logmnr_uid IN NUMBER,
lm_scn IN NUMBER,
lm_fdolen IN NUMBER,
lm_fdovalue IN RAW,
lm_charsetid IN NUMBER,
lm_ncharsetid IN NUMBER,
lm_dbtimezonelen IN NUMBER,
lm_dbtimezone_value IN VARCHAR2,
lm_db_global_name IN VARCHAR2);
logmnr_dict_cache.coltype_name(
lm_type# IN NUMBER,
lm_csform IN NUMBER,
lm_prec IN NUMBER,
lm_scale IN NUMBER,
lm_opq_type IN VARCHAR2)
RETURN VARCHAR2;
logmnr_dict_cache.getTableMCV(
logmnruid IN NUMBER,
baseobjnum IN NUMBER,
baseobjver IN NUMBER,
unsupportedcolsmask IN NUMBER,
tablepropertymask IN NUMBER,
parttype IN NUMBER,
logmnrtloflags IN NUMBER,
complextypecols IN NUMBER,
forctas IN BOOLEAN,
logmnrmcv OUT VARCHAR2,
fast_start_gather_version IN NUMBER);
logmnr_dict_cache.gsii(
lm_logmnr_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_bo#_out OUT NUMBER,
lm_indtype#_out OUT NUMBER,
lm_type# IN NUMBER,
lm_fsflags IN NUMBER,
lm_as_of_scn IN NUMBER);
logmnr_dict_cache.gtlo3b(
logmnr_uid_in IN NUMBER,
obj#_in IN NUMBER,
objv#_in IN NUMBER,
lvlcnt_out OUT NUMBER,
bo#_out OUT NUMBER,
lvl1obj#_out OUT NUMBER,
lvl2obj#_out OUT NUMBER,
lvl0type#_out OUT NUMBER,
lvl1type#_out OUT NUMBER,
lvl2type#_out OUT NUMBER,
owner#_out OUT NUMBER,
ownername_out OUT VARCHAR2,
lvl0name_out OUT VARCHAR2,
lvl1name_out OUT VARCHAR2,
lvl2name_out OUT VARCHAR2,
assoc#_out OUT NUMBER,
cols_out OUT NUMBER,
intcols_out OUT NUMBER,
kernelcols_out OUT NUMBER,
tab_flags_out OUT NUMBER,
trigflag_out OUT NUMBER,
obj_flags_out OUT NUMBER,
ts#_out OUT NUMBER,
tsname_out OUT VARCHAR2,
property_out OUT NUMBER,
start_scn_out OUT NUMBER,
unsupportedcols_out OUT NUMBER,
logmnrmcv_out OUT VARCHAR2,
complextypecols_out OUT NUMBER,
ntparentobjnum_out OUT NUMBER,
ntparentobjversion_out OUT NUMBER,
ntparentintcolnum_out OUT NUMBER,
tloflags_out OUT NUMBER,
parttype_out OUT NUMBER,
subparttype_out OUT NUMBER,
objv#_out OUT NUMBER,
indtype#_out OUT NUMBER,
as_of_scn_in IN NUMBER,
flags_fast_start IN NUMBER,
acdrflags_out OUT NUMBER,
acdrtsobj#_out OUT NUMBER,
acdrrowtsintcol#_out OUT NUMBER);
logmnr_dict_cache.logmnr$clone_key_gg(
lm_logmnr_uid IN NUMBER,
lm_baseobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_fsflags IN NUMBER,
lm_start_scn IN NUMBER);
logmnr_dict_cache.logmnr$col_gg(
lm_session# IN NUMBER,
lm_mdh IN NUMBER,
lm_obj# IN NUMBER,
lm_objv# IN NUMBER,
lm_commit_scn IN NUMBER,
result_set OUT system.logmnr$col_gg_recs);
logmnr_dict_cache.logmnr$key_gg(
lm_session# IN NUMBER,
lm_mdh IN NUMBER,
lm_baseobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_commit_scn IN NUMBER,
lm_flags IN NUMBER,
result_set OUT system.logmnr$key_gg_recs);
logmnr_dict_cache.logmnr$populate_cache_part(
lm_logmnr_uid IN NUMBER,
lm_baseobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_start_scn IN NUMBER,
lm_xidusn IN NUMBER,
lm_xidslt IN NUMBER,
lm_xidsqn IN NUMBER,
lm_fsflags IN NUMBER);
logmnr_dict_cache.logmnr$seq_gg(
lm_session# IN NUMBER,
lm_mdh IN NUMBER,
lm_obj# IN NUMBER,
lm_commit_scn IN NUMBER,
result_set OUT system.logmnr$seq_gg_recs)
logmnr_dict_cache.logmnr$tab_gg(
lm_session# IN NUMBER,
lm_mdh IN NUMBER,
lm_obj# IN NUMBER,
lm_objv# IN NUMBER,
lm_commit_scn IN NUMBER,
result_set OUT system.logmnr$tab_gg_recs)
logmnr_dict_cache.logmnr$user_gg(
lm_session# IN NUMBER,
lm_mdh IN NUMBER,
lm_commit_scn IN NUMBER,
lm_userid IN NUMBER,
lm_username IN VARCHAR2,
result_set OUT system.logmnr$user_gg_recs);
logmnr_dict_cache.logmnr_gcid(
lm_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_scn IN NUMBER,
lm_fsflags IN NUMBER,
trace IN BOOLEAN,
tsn OUT NUMBER,
tsname OUT VARCHAR2,
chunk OUT NUMBER,
start_scn_out OUT NUMBER,
drop_scn_out OUT NUMBER);
logmnr_dict_cache.logmnr_tspart_info(
lm_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_table IN VARCHAR2,
lm_drop_scn IN NUMBER,
lm_fsflags IN NUMBER,
trace IN BOOLEAN
logmnr_dict_cache.mid_process_ctas(
logmnr_uid_in IN NUMBER,
pre10i_in IN NUMBER,
post10_2_in IN NUMBER,
base_obj#_in IN NUMBER,
base_objv#_in IN NUMBER,
tab_property_in IN NUMBER,
fast_start_gather_version IN NUMBER,
atb_add_iden IN NUMBER);
logmnr_dict_cache.savedrp_obj(
lm_logmnr_uid IN NUMBER,
lm_keyobj# IN NUMBER,
lm_baseobjv# IN NUMBER,
lm_type# IN NUMBER,
lm_drop_scn IN NUMBER,
lm_fsflags IN NUMBER,
lm_as_of_scn IN NUMBER);
logmnr_dict_cache.save_colset(
lm_logmnr_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_objv# IN NUMBER,
querysource IN NUMBER,
lm_fsflags IN NUMBER,
lm_as_of_scn IN NUMBER);
logmnr_dict_cache.save_colset_at(
lm_logmnr_uid IN NUMBER,
lm_obj# IN NUMBER,
lm_objv# IN NUMBER,
querysource IN NUMBER,
lm_fsflags IN NUMBER,
lm_as_of_scn IN NUMBER);