title: Insert using DB link from one DB to another
body: <p>I am trying to copy records from one DB to another. Below is my query and the error i am getting: </p>
  
  <pre><code>INSERT INTO RDW.rdw_sdm_trader_sls_brn_cst_v
  SELECT * from RDW.rdw_sdm_trader_sls_brn_cst_v@DB_DWHPRD_RDW
  WHERE DIVISION_CODE = 'EH' and rownum &lt;= 100
  </code></pre>
  
  <p>-</p>
  
  <pre><code>*Error at Command Line:4 Column:0*        
  *Error report:*  
  *SQL Error: ORA-01779: cannot modify a column which maps to a non key-preserved table*
  01779. 00000 -  "cannot modify a column which maps to a non key-preserved table"*  
  *Cause:    An attempt was made to insert or update columns of a join view which*
             *map to a non-key-preserved table.*  
  *Action:   Modify the underlying base tables directly.*
  </code></pre>