title: oracle insert using DBlink
body: <p>I have two different databases, say DB1 and DB2.  In both DBs I have a common table called test_emp, but there is a difference in the columns of the tables:</p>
  
  <p>DB1</p>
  
  <pre><code>-----
  desc table1
  --------------
  empno               number
  ename               varchar2
  sal                 number
  hiredate            date
  deptno              number
  </code></pre>
  
  <p>DB2</p>
  
  <pre><code>-----
  desc table2
  --------------
  empno               number
  ename               varchar2
  sal                 number
  
  insert into table1 select * from table2@DBLink_Name
  </code></pre>
  
  <p>But here I have a problem with number of columns, target table has more columns than the source.
  Here I can't specify <code>column_names</code> because I am passing table as dynamic.</p>
  
  <p>Can you somebody please help?</p>