title: copy from one database to another using oracle sql developer - connection failed
body: <p>I am trying to copy a table from one database to another using oracle sql developer. I have the username, password and SIDs.</p>
  
  <pre><code>copy from uname1/password1@SID1 to uname2/pwd2@SID2 insert table1 (*) using (select * from message_table);
  </code></pre>
  
  <p>However I am getting the <code>connection failed</code> error.</p>
  
  <p>The two databases are present in different host hosts (the hostname is different in connection properties).</p>
  
  <p>The table has 5 million records and is too cumbersome to export/import</p>