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
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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_LOGREP_DEF_PROC_UTL
DBMS_LOGREP_IMP
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx