RE: Bug regarding logical standby

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark Bole

>Ideally, integrity is enforced on the primary, not the logical standby.

  The other part of the work-around is to bypass the guard if needed (DBMS_LOGSTDBY.GUARD_BYPASS_ON) and update the non-schema DDL directly on the logical standby.

In many ways the non schema ddl integrity is no less important than the data integrity, it may be somewhat easier to detect and fix. The ultimate skip non schema ddl is something that makes me feel uneasy.

So far I see the following solutions:

• Install error handler which logs failed DDL.
• Analyze it, reapply if neccesary
• Ideally it would be the best to detect "internal Oracle sql" and skip it in the error handler. Unfortunately the error handler has no table(s) parameter, just thew whole Sql statement string (i.e. 4k of it.) If one wants to detect a grant on oracle temp table then it is necessary to parse this statement string. -What else can be done? Wait for Oracle patch I assume.

--
http://www.freelists.org/webpage/oracle-l