DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2006

    Oracle Change Data Capture

    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).

    Thanks for your valuable suggestions.

  2. #2
    Join Date
    May 2000
    Configure PHYSICL STANDBY database.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.