RE: Bug regarding logical standby

From: Laimutis Nedzinskas <lnd_at_HNIT.is>
Date: Fri, 2 Dec 2005 09:29:28 -0000
Message-ID: <B201EF146906A446B13E38A111BD83791F5969@HNIT-SEIFUR>

First of all, even as of version 10g R1, the same Oracle generated temp tables problem(grants, etc) persists. For 10g the Recycle bin (which can be disabled) is not supported too.
Skip NON_SCHEMA_DDL does help but what about integrity?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: 1. desember 2005 16:24
To: oracle-l_at_freelists.org
Subject: Bug regarding logical standby

We have encountered bug 4075120 when trying to get our logical standby working.

Basically, the logical standby fails to skip ddl (such as grants) related to temp tables
that got created on the primary but do not exist on the standby.

The bugreport says it's fixed in 9.2.0.8, which doesn't appear to have been released yet.

Has anybody else encountered this error and figured a way around it?

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 02 2005 - 03:32:59 CST