| Skip Tables [message #216374] |
Fri, 26 January 2007 18:12  |
toshidas2000
Messages: 120
Registered: November 2005
|
Senior Member |
|
|
All
In my Logical configuration, bunch of tables has been skipped by exec dbms_logstdby.skip and bunch of them by DBMS_LOGSTDBY.SKIP_ERROR, what is the difference??
How do I check which tables are skipped??
I checked the view DBA_LOGSTDBY_SKIP, very interesting, it has name of all schema and in name it has wild card %..
Please help.
Thanks
Toshi Das
|
|
|
|
| Re: Skip Tables [message #216421 is a reply to message #216374] |
Sat, 27 January 2007 09:13  |
email.sandeepnaik
Messages: 121
Registered: August 2006
|
Senior Member |
|
|
DBMS_LOGSTDBY.SKIP_ERROR -->
This procedure can be used to skip a transaction that has failed and, as a result, caused logical apply to stop.
DBMS_LOGSTDBY.SKIP -->
By default, all SQL statements executed on a primary database are applied to a logical standby database. If only a subset of activity on a primary database is of interest for replication, use the DBMS_LOGSTDBY.SKIP procedure to define filters that prevent the application of SQL statements on the logical standby database.
DBA_LOGSTDBY_SKIP view -->
Lists the DML and DDL that is to be skipped. This view reflects the options chosen by the DBMS_LOGSTDBY.SKIP and the DBMS_LOGSTDBY.SKIP_ERROR procedures. The DBA_LOGSTDBY_SKIP view does not list tables.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
