prepared for the release of Oracle Database
18c ... the first autonomous database? We are here at the Library. It is
time for DBAs to stop fighting robots with their fingers and losing ...
time to start using our intelligence and winning.
As of Oracle Database 12c release 1 (12.1), SQL Apply processes have access to a context namespace called LSBY_APPLY_CONTEXT.
You can use the procedures provided in the DBMS_LOGSTDBY_CONTEXT package to set and retrieve various parameters associated with LSBY_APPLY_CONTEXT.
This is useful when writing skip procedures that are registered with SQL Apply using the DBMS_LOGSTBDY.SKIP and DBMS_LOGSTDBY.SKIP_ERROR procedures.
CREATE CONTEXT lsby_apply_context USING dbms_logstdby_context;