Re: ** replication remove

  • From: "Yavor Ivanov" <Yavor_Ivanov@xxxxxxxx>
  • To: ajoshi977@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 23 Oct 2006 17:26:09 +0300

        What kind of replication? Master2Master, Mview, Streams?
        What version of oracle?
        I did not play with catrepr, but according to metalink note 241943.1 
CATREPR.SQL id no longer supported as of 9.2.0.2

Regards,
Yavor

On Sun, 22 Oct 2006 17:41:03 +0300, A Joshi <ajoshi977@xxxxxxxxx> wrote:

> Hi,
>     I am planning to copy a database that is replicated to another server. It 
> will not be replicated on this new server. So in order to remove replication 
> I plan to remove all replication software using catrepr.sql.
>   I think last time I did this I also had to execute 
> sys.dbms_internal_trigger.destroy
>   for some tables. So my question is is catrepr.sql enough to remove 
> replication or is there a better way to remove the replication. Or some order 
> to be followed. Thanks for the help.
>
>                               
> ---------------------------------
> Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small 
> Business.

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


Other related posts: