If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Oracle Change Data Capture

We are planning to capture changed data in the Oracle source system. If any DDL changes as well as DML changes need to capture (if table level changes, new tables has created or data modified) all these need to reflect in the target database.

If any one suggests best options are highly appreciated:

We thought of

1 CDC : For implementing CDC need to create Change tables in the Source system.
If user does not allow, is there any possibility to create change tables target database.

2. Is there any possibility to Create triggers on the source table for capturing
DML and DDL changes reflect on target database.(need to capture new tables also).