How to disable synchronous CDC in 9i ?
we're patching an application running on 18.104.22.168 database to a higher version. The scripts are doing some changes in the database we don't need to capture (performance issues, database is 5TB in size).
Is there any way to temporarily disable the CDC ?
We don't want to drop change tables and create them after the patching process. We can't change the scripts in a patch.
Using rmcdc.sql script doesn't work - the changes are still visible in CDC tables.
Is there a possibility to disable the triggers used in capture process ?
Thanks for any help,
Click Here to Expand Forum to Full Width