RE: Bug regarding logical standby
- From: "Laimutis Nedzinskas" <lnd@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Dec 2005 09:29:10 -0000
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
