DBA_LOGSTDBY_SKIP

DBA_LOGSTDBY_SKIP displays the skip rules that are used by SQL Apply. This view is for logical standby databases only.

Column Datatype NULL Description
ERROR VARCHAR2(1)   Indicates how the skip rule was created:

  • Y - For rules from DBMS_LOGSTDBY.SKIP_ERROR

  • N - For rules from DBMS_LOGSTDBY.SKIP
STATEMENT_OPT VARCHAR2(30)   Specifies the type of statement that should be skipped
OWNER VARCHAR2(30)   Name of the schema under which the skip option should be used
NAME VARCHAR2(65)   Name of the table that is being skipped
USE_LIKE VARCHAR2(1)   Indicates whether the statement should use a SQL wildcard search when matching names (Y) or not (N)
ESC VARCHAR2(1)   Escape character used when performing wildcard matches
PROC VARCHAR2(98)   Name of a stored procedure that will be executed when processing the skip option