Oracle | DBMS_APPLY

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