DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Change Data Capture

  1. #1
    Join Date
    Dec 2006
    Posts
    1

    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
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Configure PHYSICL STANDBY database.

    Tamil

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