We have a multimaster environment, where master definition site is in Buffalo, and two master sites are in Hongkong and france. Now the france has been disconnected, but still the deferred transactions are produced for france. So we run a oracle supplied package to delete these transactions in Buffalo. Unfortunately for long time they didn’t do that in france and now it has gone over 6 million records. Now I need to delete that. The size of the table approximately may be 4GB . Now to delete the records, how should I configure rollback segments and what are the other considerations I should take care of.

My next doubt is how to stop the production of the deferred transactions to france.

Thanks & Regards
Prasanna S.