Oracle | DBMS_LOGREP

Oracle DBMS_LOGREP_EXP Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Log file replication support utilities

AUTHID CURRENT_USER

Dependencies

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

Documented No

First Available Not known

Security Model Owned by SYS with EXECUTE granted to PUBLIC and the OGG_APPLY, OGG_CAPTURE, XSTREAM_APPLY and XSTREAM_CAPTURE roles.

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.4', 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('23.4');

      

      DBMS_LOGREP_EXP.version_VAR2_2_NUMBER('23.4')

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

                                               23.4

      

      SELECT dbms_logrep_exp.version_var2_2_number('23.4.0.0');

      

      DBMS_LOGREP_EXP.version_VAR2_2_NUMBER('23.4.0.0')

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

                                                 
      23.400