Re: Query on Database Link

Hi

Try

Create database link test2
connect to <remote_user> identified by <password> using 'test2';

make sure that test2 is in the tnsnames.ora file on the satellite server

Jack

"magesh" <magesh_at_garoo.ne.jp>@fatcity.com on 09/26/2000 11:00:35 AM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Query on Database Link

Hi All

  How to create a database link to access from one database to another Received on Tue Sep 26 2000 - 05:32:26 CDT