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 will be available on generic Linux platforms in January and soon on AIX and Windows

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