Oracle | DBMS_LOGREP

Oracle DBMS_LOGREP_EXP 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 Log file replication support utilities

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBA_USERS	_DBA_APPLY
ANYDATA	DBMS_AQ_SYS_EXP_ACTIONS	_DBA_APPLY_CONF_HDLR_COLUMNS
DBA_APPLY_DML_HANDLERS	DBMS_AQ_SYS_EXP_INTERNAL	_DBA_APPLY_ERROR
DBA_APPLY_KEY_COLUMNS	DBMS_ASSERT	_DBA_APPLY_ERROR_HANDLER
DBA_APPLY_PARAMETERS	DBMS_DATAPUMP	_DBA_APPLY_ERROR_TXN
DBA_APPLY_TABLE_COLUMNS	DBMS_FILE_GROUP_EXP	_DBA_APPLY_MILESTONE
DBA_CAPTURE_EXTRA_ATTRIBUTES	DBMS_FLASHBACK	_DBA_APPLY_PROGRESS
DBA_CAPTURE_PARAMETERS	DBMS_GOLDENGATE_EXP	_DBA_APPLY_SOURCE_OBJ
DBA_CAPTURE_PREPARED_DATABASE	DBMS_LOGMNR_LOGREP_DICT	_DBA_APPLY_SOURCE_SCHEMA
DBA_CAPTURE_PREPARED_SCHEMAS	DBMS_LOGREP_UTIL	_DBA_CAPTURE
DBA_CAPTURE_PREPARED_TABLES	DBMS_METADATA	_DBA_STREAMS_MESSAGE_CONSUMERS
DBA_OBJECTS	DBMS_STANDARD	_DBA_STREAMS_MESSAGE_RULES
DBA_PROPAGATION	DBMS_STREAMS_ADM_UTL	_DBA_STREAMS_MSG_NOTIFICATIONS
DBA_QUEUES	DBMS_STREAMS_DATAPUMP_UTIL	_DBA_STREAMS_PRIVILEGED_USER
DBA_STREAMS_TRANSFORMATIONS	DBMS_STREAMS_DECL	_DBA_STREAMS_RULES
DBA_SYNC_CAPTURE_PREPARED_TABS	DBMS_UTILITY	_DBA_STREAMS_RULES_H

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/prvthlin.plb

Subprograms

ANYDATA_IMPORT_STRING	INTERNAL_TRANSFORM_EXPORT	SYSTEM_INFO_EXP
INSTANCE_EXTENDED_INFO_EXP	SCHEMA_INFO_EXP	VERSION_VAR2_2_NUMBER

ANYDATA_IMPORT_STRING

Undocumented dbms_logrep_exp.anydata_import_string(ad IN sys.anydata) RETURN VARCHAR2;

TBD

INSTANCE_EXTENDED_INFO_EXP

Undocumented dbms_logrep_exp.instance_extended_info_exp( name IN VARCHAR2, schema IN VARCHAR2, namespace IN BINARY_INTEGER, type IN BINARY_INTEGER, prepost IN BINARY_INTEGER, exp_user IN VARCHAR2, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

INTERNAL_TRANSFORM_EXPORT

Undocumented dbms_logrep_exp.internal_transform_export( rschema IN VARCHAR2, rname IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

SCHEMA_INFO_EXP

Undocumented dbms_logrep_exp.schema_info_exp( schema IN VARCHAR2, prepost IN BINARY_INTEGER, isdba IN BINARY_INTEGER, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

TBD

SYSTEM_INFO_EXP

Undocumented

The integer parameter prepost cannot exceed 94. dbms_logrep_exp.system_info_exp( prepost IN BINARY_INTEGER, connectstring OUT VARCHAR2, version IN VARCHAR2, new_block OUT BINARY_INTEGER) RETURN VARCHAR2;

DECLARE

       x      dbms_id;

       y      dbms_id;

       retVal dbms_id;

      BEGIN

        retVal := dbms_logrep_exp.system_info_exp(94, x, '21.1', y);

        dbms_output.put_line(retVal);

        dbms_output.put_line(x);

        dbms_output.put_line(y);

      END;

      /

      

      PL/SQL procedure successfully completed.

VERSION_VAR2_2_NUMBER

Undocumented dbms_logrep_exp.version_var2_2_number(var_version IN VARCHAR2) RETURN NUMBER;

SELECT dbms_logrep_exp.version_var2_2_number('21.1')

      FROM dual;

      

      DBMS_LOGREP_EXP.version_VAR2_2_NUMBER('21.1')

      ---------------------------------------------

                                               21.1

      

      SELECT dbms_logrep_exp.version_var2_2_number('21.1.0.1')

      FROM dual;

      

      DBMS_LOGREP_EXP.version_VAR2_2_NUMBER('21.1.0.1')

      -------------------------------------------------

                                                 21.101