Re: Bug regarding logical standby

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 01 Dec 2005 08:40:20 -0800
Message-ID: <438F2774.8020204@pacbell.net>

Adams, Matthew (GE Consumer & Industrial) wrote:

> 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?
>

Try this, it worked for me in the same situation (grants).

DBMS_LOGSTDBY.SKIP('NON_SCHEMA_DDL');

-- 
Mark Bole
http://www.bincomputing.com



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

Received on Thu Dec 01 2005 - 10:48:57 CST