How to copy data from one database/table to another database/table
I have written the following query using the documentation at: [Oracle Documentation][1] to copy some data from a database/table on my production server to database/table on Sandbox server.

`COPY FROM username1/passwd1@<production_IP> to username2/passwd2@<sandbox_IP> INSERT TABLE_C (*) USING 
(SELECT * FROM TABLE_C WHERE COL_A = 4884);`

However, I am constantly running into `Connection failed` error. Is there anything wrong with the query?


  [1]: http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm
How to copy data from one database/table to another database/table
===

I have written the following query using the documentation at: [Oracle Documentation][1] to copy some data from a database/table on my production server to database/table on Sandbox server.

`COPY FROM username1/passwd1@<production_IP> to username2/passwd2@<sandbox_IP> INSERT TABLE_C (*) USING 
(SELECT * FROM TABLE_C WHERE COL_A = 4884);`

However, I am constantly running into `Connection failed` error. Is there anything wrong with the query?


  [1]: http://docs.oracle.com/cd/B10500_01/server.920/a90842/apb.htm