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
by OWNER;
OWNER NAME ERR STAT
------------------------------ ------------------------------ --- ----
USERA % N DML
USERB TABLE1 N DML
USERB TABLE2 N DML
USERC % N DML
4 rows selected.
SQL>
Thanks,
Roger Xu
Other related posts:
