Hi All,

I am facing some problem with oracle replication set up. I have a replication set up already running fine. There is a table called Emp_temp in the replication group which is in ASYNCHRONOUS mode(replicating data for every 15 min). My application is writing data into this table which is in primary server (there are only two servers in the set up i.e. primary and secondary).

I want to stop the replication but my application should keep on writing to Emp_temp table even after replication stopped. But when I stopped the replication (through oemapp GUI) my application is throwing errors stating that it could not commit to that table. Can anyone tell me how to gracefully stop the replication? Is there any way even after stopping the replication application can continue writing to the Emp_temp table?

Your early reply is highly appreciated

Thanks in advance.