Re: dataguard logical standby issue
- From: "Edward Lewis" <eglewis@xxxxxxxxxxx>
- To: "Mark Strickland" <strickland.mark@xxxxxxxxx>
- Date: Mon, 19 Mar 2007 13:53:01 -0700
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@xxxxxxxxx> 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@xxxxxxxxxxx
--
http://www.fastmail.fm - Faster than the air-speed velocity of an
unladen european swallow
--
//www.freelists.org/webpage/oracle-l
Other related posts:
