Re: Transferring data between two databases if there is a LINK between them

From: Shashank Tripathi <shanx_at_shanx.com>
Date: Fri, 03 Dec 1999 16:52:07 GMT
Message-ID: <3847f43b.3881223@news.netvigator.com>

HI Ben

You dont really need to run the stored procedure on the UNIX server if you dont want to. SQL Plus will recognize the database link just fine.

Connect to DB_1 and try running the following simple SQL commands:

SQL> create database link l_link

	connect to ben_heuer 
	identified by ben_pass 
	using 'DB_2';

SQL> select * from TABLE_2_at_DB_2;

The DB_1 and DB_2 are TNS names (names you gave while setting up your TNS to these databases).

Mail me off the group for a more detailed working example.

HTH,
Shanx

---

Shashank Tripathi
http://shanx.com Received on Fri Dec 03 1999 - 10:52:07 CST