Is there any connection between Streams and CDC?
Hi - my customer has encountered the ORA-600 [17113] when using her 9i database, and as a workaround she has been advised to disable the triggers associated with CDC by running these statements as SYSDBA (she doesn't use CDC):
ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_drop_ctable_before DISABLE; .
However, this database has a Streams 'capture' process running on it to replicate data from some tables to another database. This database is so important to the customer that she needs to be absolutely certain that this will have no adverse effect on the working of the Streams capture process. I can see no connection between these CDC triggers and the Streams processes, but do you know whether there could be any impact on the Streams capture process if these CDC triggers are disabled, please?
ALTER TRIGGER sys.cdc_alter_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_after DISABLE;
ALTER TRIGGER sys.cdc_create_ctable_before DISABLE;
ALTER TRIGGER sys.cdc_drop_ctable_before DISABLE; .
However, this database has a Streams 'capture' process running on it to replicate data from some tables to another database. This database is so important to the customer that she needs to be absolutely certain that this will have no adverse effect on the working of the Streams capture process. I can see no connection between these CDC triggers and the Streams processes, but do you know whether there could be any impact on the Streams capture process if these CDC triggers are disabled, please?
0