I have two remote servers(Server-1 and Server-2) where oracle installed. I have one table in Server-2 which I want to copy in Server-1.
Kindly let me know the procedure and script to copy. I have credentials and ip-address of both the server.
Two options comes to mind immediately.
1. You can create a Database Link and perform INSERT INTO... SELECT * FROM or CREATE TABLE.. AS SELECT * FROM
2. You can Export and Import the table using Data Pump. Oracle provides DBMS_DATAPUMP API for this purpose.
What is your DB version?
For 10g and later, you can use DATA PUMP. Here are few examples http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php