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
Answer is A:
For source and target structures to be identical, they must:
● be of the same database type, i.e. all Oracle.
● have the same character set and locale.
● contain the same number of columns.
● have identical column names (including case, white spaces, and quotes if applicable).
● have identical data types.
● have identical column lengths.
● have the same column length semantics for character columns (bytes versus
characters).
● define all of the columns in the same order.