5.170 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(128)

Specifies the type of statement that should be skipped

OWNER

VARCHAR2(128)

Name of the schema under which the skip option should be used

NAME

VARCHAR2(261)

Name of the object 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(392)

Name of a stored procedure that will be executed when processing the skip option

See Also: