-
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.
with regards
Prasanna S
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|