Oracle | DBMS_LOGMNR_LOGREP

Oracle DBMS_LOGMNR_LOGREP_DICT Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

Purpose Undocumented

AUTHID DEFINER

Dependencies

(Only)DBMS_LOGMNR_INTERNAL	DBMS_STREAMS_ADM_UTL	LOGMNR_DICT_CACHE
DBMS_LOGREP_EXP	DBMS_SYSTEM	LOGMNR_UID$
DBMS_OUTPUT	DBMS_SYS_SQL	LOGMNR_UIDS$
DBMS_SQL	DUAL	OBJ$
DBMS_STATS	LOGMNRC_DBNAME_UID_MAP	USER$

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

Source {ORACLE_HOME}/rdbms/admin/prvtlmrs.plb
{ORACLE_HOME}/rdbms/admin/prvtlmrb.plb

Subprograms

ADD_COL	DEL_OBJ	PURGE_SCN
ADD_GLOBAL_NAME	PURGE_GLOBAL_NAME	ROLLBACK_XID
ADD_OBJ	PURGE_OBJ	SYSTEM_INFO_EXP
COMMIT_XID

ADD_COL

Undocumented

Overload 1 dbms_logmnr_logrep_dict.add_col( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, segcol# IN NUMBER, intcol# IN NUMBER, colname IN VARCHAR2, type# IN NUMBER, length IN NUMBER, precision IN NUMBER, scale IN NUMBER, property IN NUMBER, charsetid IN NUMBER, charsetform IN NUMBER);

TBD

Overload 2 dbms_logmnr_logrep_dict.add_col( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, segcol# IN NUMBER, intcol# IN NUMBER, col# IN NUMBER, colname IN VARCHAR2, type# IN NUMBER, length IN NUMBER, precision IN NUMBER, scale IN NUMBER, property IN NUMBER, charsetid IN NUMBER, charsetform IN NUMBER, xtypeschemaname IN VARCHAR2, xtypename IN VARCHAR2, xfqcolname IN VARCHAR2, xtopintcol IN NUMBER, xreffedtableobjn IN NUMBER, xreffedtableobjv IN NUMBER, xcoltypeflags IN NUMBER, xopqtypetype IN NUMBER, xopqtypeflags IN NUMBER, xopqlobintcol IN NUMBER, xopqobjintcol IN NUMBER, xxmlintcol IN NUMBER);

TBD

Overload 3 dbms_logmnr_logrep_dict.add_col( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, segcol# IN NUMBER, intcol# IN NUMBER, col# IN NUMBER, colname IN VARCHAR2, type# IN NUMBER, length IN NUMBER, precision IN NUMBER, scale IN NUMBER, property IN NUMBER, charsetid IN NUMBER, charsetform IN NUMBER, xtypeschemaname IN VARCHAR2, xtypename IN VARCHAR2, xfqcolname IN VARCHAR2, xtopintcol IN NUMBER, xreffedtableobjn IN NUMBER, xreffedtableobjv IN NUMBER, xcoltypeflags IN NUMBER, xopqtypetype IN NUMBER, xopqtypeflags IN NUMBER, xopqlobintcol IN NUMBER, xopqobjintcol IN NUMBER, xxmlintcol IN NUMBER, pdb_name IN VARCHAR2, logmnr_mdh IN NUMBER, logmnrderivedflags IN NUMBER);

TBD

ADD_GLOBAL_NAME

Undocumented dbms_logmnr_logrep_dict.add_global_name(global_dbname IN VARCHAR2);

exec dbms_logmnr_logrep_dict.add_global_name('test21db');

      

      PL/SQL procedure successfully completed.

ADD_OBJ

Undocumented

Overload 1 dbms_logmnr_logrep_dict.add_obj( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, objtype IN NUMBER, owner# IN NUMBER, ownername IN VARCHAR2, objname IN VARCHAR2, numcols IN NUMBER, scn IN NUMBER xidusn IN NUMBER xidslt IN NUMBER xidsqn IN NUMBER kernelcols IN NUMBER);

TBD

Overload 2 dbms_logmnr_logrep_dict.add_obj( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, objtype IN NUMBER, owner# IN NUMBER, ownername IN VARCHAR2, objname IN VARCHAR2, numcols IN NUMBER, scn IN NUMBER, xidusn IN NUMBER, xidslt IN NUMBER, xidsqn IN NUMBER, kernelcols IN NUMBER, unsupportedcols IN NUMBER, complextypecols IN NUMBER, ntparentobjnum IN NUMBER, ntparentobjversion IN NUMBER, ntparentobjintcolnum IN NUMBER, logmnrtloflags IN NUMBER, trigflag IN NUMBER);

TBD

Overload 3 dbms_logmnr_logrep_dict.add_obj( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, objtype IN NUMBER, owner# IN NUMBER, ownername IN VARCHAR2, objname IN VARCHAR2, numcols IN NUMBER, scn IN NUMBER, xidusn IN NUMBER, xidslt IN NUMBER, xidsqn IN NUMBER, kernelcols IN NUMBER, unsupportedcols IN NUMBER, complextypecols IN NUMBER, ntparentobjnum IN NUMBER, ntparentobjversion IN NUMBER, ntparentobjintcolnum IN NUMBER, logmnrtloflags IN NUMBER, trigflag IN NUMBER, pdb_name IN VARCHAR2, logmnr_mdh IN NUMBER);

TBD

COMMIT_XID

Undocumented dbms_logmnr_logrep_dict.commit_xid( global_name IN VARCHAR2, source_version IN NUMBER, xidusn IN NUMBER, xidslt IN NUMBER, xidsqn IN NUMBER);

TBD

DEL_OBJ

Undocumented dbms_logmnr_logrep_dict.del_obj( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER, drop_scn IN NUMBER);

TBD

PURGE_GLOBAL_NAME

Undocumented dbms_logmnr_logrep_dict.purge_global_name( global_name IN VARCHAR2, source_version IN NUMBER);

TBD

PURGE_OBJ

Undocumented dbms_logmnr_logrep_dict.purge_obj( global_name IN VARCHAR2, source_version IN NUMBER, obj# IN NUMBER, objv# IN NUMBER);

TBD

PURGE_SCN

Undocumented dbms_logmnr_logrep_dict.purge_scn( global_name IN VARCHAR2, source_version IN NUMBER, scn IN NUMBER);

TBD

ROLLBACK_XID

Undocumented dbms_logmnr_logrep_dict.rollback_xid( global_name IN VARCHAR2, source_version IN NUMBER, xidusn IN NUMBER, xidslt IN NUMBER, xidsqn IN NUMBER);

TBD

SYSTEM_INFO_EXP

Undocumented dbms_logmnr_logrep_dict.system_info_exp( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD