Hi,

 

I have a few questions on Asynch CDC, in regards to setting up the change table.

 

1. After letting dbms_cdc_publish.create_change_table create the change table, is it ok to (manually) add columns to it? I need to add a couple of snapshot columns that are not present in the base table.

2. Would it be possible to implement a database insert trigger on the change table to populate the snapshot columns of the change table?

3. Does Async CDC partition the change table automatically? If so, what is the partitioning scheme? (The manual simply tells "Change Data Capture automatically manages the change table partitioning as part of its change table management")

Thanks in advance,
--
Arul