Does Oracle Stream data replication requires identical tables structure between source and Target Databases?

5 pts.
Tags:
Data Replication
Oracle Stream Data Replication
Oracle Streams
Oracle Table
We are considering the use of Oracle Data Stream to replicate data from operations database to a separate Helpdesk database. Our users require near real-time data loaded in the helpdesk database. What are the constraints imposed by Oracle streams for table design? Does it require for tables structure (including ordering of columns) to be identical in both databases? Can we have different PKs columns in tables of two databases?

Answer Wiki

Thanks. We'll let you know when a new response is added.

This is really a question of requirements and possibilities. I am presuming that you have looked over the High Availability and Replication documentation and you are looking for something more flexible.

In Streams, there are no explicit constraints for table design or structure. Yes, you can have different PKs in tables of two databases. That being sai

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following