For replication purpose can you treat these as identical tables?

You are configuring replication between two Oracle tables with the same number of columns,
column table names, and data types, but in different orders. For replication purpose can you treat
these as identical tables?

You are configuring replication between two Oracle tables with the same number of columns,
column table names, and data types, but in different orders. For replication purpose can you treat
these as identical tables?

A.
No

B.
Yes, if the source and target Oracle versions and character sets are the same.

C.
Yes

D.
Yes, as long as the source table has a primary key define

Explanation:
In reference guide, page 119, when replicating from identical sources to targets, the param
ASSUMETARGETDEFS must be used, and the only with being with columns in different orders,
the answer is NO



Leave a Reply 1

Your email address will not be published. Required fields are marked *


marco procida

marco procida

In the reference guide for 11g is page 121