Re: dataguard logical standby issue

Hi Mark,

    It's Oracle 10.2.0.2.
Yes, I did try the 2 statements you mentioned. It appeared to bypass the original error, but then I encountered an error doing a "COMMENT ON TABLE" command. The error generated was a ORA-00942, table or view does not exist.

    I think this statement is being executed on the SYSMAN schema, which supposedly should be skipped.

thanks for your suggestions.

   ed  

On Mon, 19 Mar 2007 13:24:03 -0700, "Mark Strickland" <strickland.mark_at_gmail.com> said:
> I don't think you mentioned the version of Oracle you're on, but did you
> try
> this?
>
> exec dbms_logstdby.skip('SCHEMA_DDL','SYSMAN','%',null);
> exec dbms_logstdby.skip('DML','SYSMAN','%',null);
>
> This is what I used in 10.1.0.3 (now 10.1.0.5) for each schema that I did
> not want to be included in the replication scheme.
>
> Mark

-- 
  Edward Lewis
  eglewis_at_fastmail.fm

-- 
http://www.fastmail.fm - Faster than the air-speed velocity of an
                          unladen european swallow

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