Oracle | DBMS_APPLY

Oracle DBMS_APPLY_POSITION 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 Streams Logical Change Record Utilities

AUTHID DEFINER

Dependencies

DBMS_LOGREP_UTIL

LCR$_DDL_RECORD

LCR$_ROW_RECORD

Documented No

First Available Not Known

Security Model Owned by SYS with EXECUTE granted to the EXECUTE_CATALOG_ROLE role.

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

Subprograms

GET_EXTERNAL_POSITION	SET_SCHEMA_INSTANTIATION_SCN	SET_TABLE_INSTANTIATION_SCN
SET_GLOBAL_INSTANTIATION_SCN

GET_EXTERNAL_POSITION

Undocumented

Overload 1 dbms_apply_position.get_external_position(rowlcr IN sys.lcr$_row_record) RETURN RAW;

TBD

Overload 2 dbms_apply_position.get_external_position(ddllcr IN sys.lcr$_ddl_record); RETURN RAW;

TBD

SET_GLOBAL_INSTANTIATION_SCN

Undocumented dbms_apply_position.set_global_instantiation_scn( source_database_name IN VARCHAR2, external_position IN RAW);

TBD

SET_SCHEMA_INSTANTIATION_SCN

Undocumented dbms_apply_position.set_schema_instantiation_scn( source_schema_name IN VARCHAR2, source_database_name IN VARCHAR2, external_position IN RAW)

TBD

SET_TABLE_INSTANTIATION_SCN

Undocumented dbms_apply_position.set_table_instantiation_scn( SOURCE_OBJECT_NAME IN VARCHAR2, source_database_name IN VARCHAR2, external_position IN RAW);

TBD