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