Oracle | DBMS_LOGREP_IMP

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