Source Database : Oracle 9i
Target Database : Oracle 9i
Both are on Different servers.
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).