Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change Data Caputre pros/cons

743961Feb 14 2010 — edited Feb 15 2010

Hi,

I need to have separate database for reporting reasons (staging area) which should be a copy of primary database.

I’m taking into consideration Asynchronous Change Data Capture Oracle feature. Database size will be around several TBs. I am afraid about performance issues during moving data between databases.

I will appreciate if anyone can help me understand pros and cons for using asynchronous CDC or maybe I should think about something else (Data Guard?).

Thank you in advance,
M.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 15 2010

Added on Feb 14 2010

#general-database-discussions

4 comments

954 views