title: How to copy data from one database/table to another database/table
body: <p>I have written the following query using the documentation at: <a href="http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm">Oracle Documentation</a> to copy some data from a database/table on my production server to database/table on Sandbox server.</p>
  
  <p><code>COPY FROM username1/passwd1@&lt;production_IP&gt; to username2/passwd2@&lt;sandbox_IP&gt; INSERT TABLE_C (*) USING 
  (SELECT * FROM TABLE_C WHERE COL_A = 4884);</code></p>
  
  <p>However, I am constantly running into <code>Connection failed</code> error. Is there anything wrong with the query?</p>