Logical Standby - dba_logstdby_skip.error

  • From: Roger Xu <wellmetus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 14 Jan 2010 16:59:56 -0600

Hi List,

Oracle doc says that dba_logstdby_skip.error indicates "whether the
statement should be skipped (Y) or just return errors for the statement
(N)". What does this really mean?

Below shows that no DML is applied for tables owned by userA and userC. All
DML are applied for userB except table1 and table2, correct?

SQL> select OWNER, NAME, ERROR, STATEMENT_OPT from dba_logstdby_skip order

OWNER                          NAME                           ERR STAT
------------------------------ ------------------------------ --- ----
USERA                          %                              N   DML
USERB                          TABLE1                         N   DML
 USERB                          TABLE2                         N   DML
USERC                          %                              N   DML

4 rows selected.



Roger Xu

Other related posts: