Oracle
1Z0-481 · Question #69
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…
The correct answer is A. No. 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
Unidirectional Data Replication
Question
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?
Options
- ANo
- BYes, if the source and target Oracle versions and character sets are the same.
- CYes
- DYes, as long as the source table has a primary key define
How the community answered
(33 responses)- A82% (27)
- B3% (1)
- C6% (2)
- D9% (3)
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
Topics
#column ordering#table mapping#column names#data types
Community Discussion
No community discussion yet for this question.