Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: dataguard logical standby issue

Re: dataguard logical standby issue

From: Mark Strickland <strickland.mark_at_gmail.com>
Date: Mon, 19 Mar 2007 13:24:03 -0700
Message-ID: <90ad14210703191324i1baa71f2lf8211580b8844120@mail.gmail.com> 





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


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


Received on Mon Mar 19 2007 - 15:24:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US