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?
Yes, if the source and target Oracle versions and character sets are the same.
Yes, as long as the source table has a primary key define
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