I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
- 1 Answers
- 1194 Views
- Oracle, I also Faced
- E-Mail Answers
Answer / Dileep Kumar Kamal
Use Oracle's database change data capture (DBMS_RLS package) or materialized view log (MVL) based replication to handle the difference in column order.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to use "in out" parameter properly?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Are truncate and delete commands same? If so why?
What are the major difference between truncate and delete?
What is clustered table in Oracle?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
What is the difference between sharding and partitioning?
waht is referencial integrity?
How to retrieve first and last records from a table?
What are privileges and grants?
What are the trigger associated with image items ?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
