Oracle | DBMS_LOGREP_IMP

Oracle DBMS_LOGREP_IMP_INTERNAL 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 DEFINER

Dependencies

APPLY$_ERROR	DBMS_LOGREP_LIB	STREAMS$_APPLY_PROGRESS
APPLY$_ERROR_TXN	DBMS_LOGREP_UTIL	STREAMS$_PREPARE_DDL
APPLY$_SOURCE_SCHEMA	DBMS_STREAMS_DATAPUMP	STREAMS$_PRIVILEGED_USER
DBA_USERS	DUAL	STREAMS$_RULES
DBMS_LOGREP_IMP	STREAMS$_APPLY_MILESTONE	V$DATABASE
DBMS_LOGREP_IMP_INTERNAL	STREAMS$_APPLY_PROCESS	V$DATABASE_INCARNATION

First Available Not known

Security Model Owned by SYS with no privileges granted

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

Subprograms

APPLY_ERROR	INSTANTIATE	PRIVILEGED_USER
APPLY_ERROR_TXN	INSTANTIATE_SCHEMA	STREAMS_RULES
APPLY_MILESTONE	PREPARE_DDL	UPDATE_APPLY_PROCESS
APPLY_PROGRESS

APPLY_ERROR

Undocumented dbms_logrep_imp_internal.apply_error( local_tid IN VARCHAR2, source_tid IN VARCHAR2, canon_source_db IN VARCHAR2, canon_queue_owner IN VARCHAR2, canon_queue_name IN VARCHAR2, canon_apply_name IN VARCHAR2, message_number IN NUMBER, message_count IN NUMBER, min_step_no IN NUMBER, canon_recipient_name IN VARCHAR2, source_commit_scn IN NUMBER, 1error_number IN NUMBER, 1error_message IN VARCHAR2, 1aq_tid IN VARCHAR2, spare1 IN NUMBER, spare2 IN NUMBER, spare3 IN NUMBER, 1error_creation_time IN DATE);

TBD

APPLY_ERROR_TXN

Undocumented dbms_logrep_imp_internal.apply_error_txn( local_tid IN VARCHAR2, msgid IN RAW txn_message_number IN NUMBER, error_number IN NUMBER, error_message IN VARCHAR2, flags IN NUMBER, spare1 IN NUMBER, spare2 IN NUMBER, spare3 IN VARCHAR2, spare4 IN VARCHAR2, spare5 IN RAW, spare6 IN DATE, src_obj_owner IN VARCHAR2, src_obj_name IN VARCHAR2, 1dest_obj_owner IN VARCHAR2, 1dest_obj_name IN VARCHAR2, 1primary_key IN VARCHAR2, 1position IN RAW, 1message_flags IN NUMBER, operation IN VARCHAR2);

TBD

APPLY_MILESTONE

Undocumented dbms_logrep_imp_internal.apply_milestone( canon_apply_name IN VARCHAR2, canon_source_db IN VARCHAR2, oldest_scn IN NUMBER, commit_scn IN NUMBER, synch_scn IN NUMBER, epoch IN NUMBER, processed_scn IN NUMBER, apply_time IN VARCHAR2, msg_create_time IN VARCHAR2, spare1 IN NUMBER, start_scn IN NUMBER, 1oldest_transaction_id IN VARCHAR2, spill_lwm_scn IN NUMBER, lwm_external_pos IN VARCHAR2, spare2 IN NUMBER, spare3 IN VARCHAR2);

TBD

APPLY_PROGRESS

Undocumented dbms_logrep_imp_internal.apply_progress( canon_apply_name IN VARCHAR2, canon_source_db IN VARCHAR2, xidusn IN NUMBER, xidslt IN NUMBER, xidsqn IN NUMBER, commit_scn IN NUMBER, spare1 IN NUMBER);

TBD

INSTANTIATE

Undocumented dbms_logrep_imp_internal.instantiate( canon_object_owner IN VARCHAR2, canon_object_name IN VARCHAR2, object_type IN BINARY_INTEGER, canon_export_db_name IN VARCHAR2, inst_scn IN NUMBER, ignore_scn IN NUMBER);

TBD

INSTANTIATE_SCHEMA

Undocumented dbms_logrep_imp_internal.instantiate_schema( canon_schema_name IN VARCHAR2, canon_export_db_name IN VARCHAR2, inst_scn IN NUMBER, spare1 IN NUMBER);

TBD

PREPARE_DDL

Undocumented dbms_logrep_imp_internal.prepare_ddl( canon_schema_name IN VARCHAR2, flags IN BINARY_INTEGER);

exec dbms_logrep_imp_internal.prepare_ddl('C##UWCLASS', 1);

      

      PL/SQL procedure successfully completed.

PRIVILEGED_USER

Undocumented dbms_logrep_imp_internal.privileged_user( canon_username IN VARCHAR2, privs IN NUMBER);

TBD

STREAMS_RULES

Undocumented dbms_logrep_imp_internal.streams_rules( canon_streams_name IN VARCHAR2, streams_type IN BINARY_INTEGER, rule_type IN BINARY_INTEGER, include_tagged_lcr IN BINARY_INTEGER, canon_source_database IN VARCHAR2, canon_rule_owner IN VARCHAR2, canon_rule_name IN VARCHAR2, rule_condition IN VARCHAR2, dml_condition IN VARCHAR2, subsetting_operation IN BINARY_INTEGER, canon_schema_name IN VARCHAR2, canon_object_name IN VARCHAR2, 1object_type IN BINARY_INTEGER, spare1 IN NUMBER, spare2 IN NUMBER, spare3 IN NUMBER, canon_source_root IN VARCHAR2);

TBD

UPDATE_APPLY_PROCESS

Undocumented dbms_logrep_imp_internal.update_apply_process( canon_apply_name IN VARCHAR2, error_number IN NUMBER, error_message IN VARCHAR2);

TBD