Oracle DBMS_LOGREP_EXP
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
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_IMP_INTERNAL
DBMS_LOGREP_UTIL
DBMS_LOGREP_UTIL_INVOK
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx