Re: interesting problem

From: godmann <allanwtham_at_yahoo.com>
Date: 7 Sep 2001 01:52:03 -0700
Message-ID: <95cd51c.0109070052.7827a551_at_posting.google.com>


Hi there,

   There is a way you can specify which table you want.

 1.Say you have two databases: awt and awt1 and you created a databaselink    in awt by

   svrmgrl> create public database link awt1

            connect to scott identified by tiger
            using 'awt1';

 2.Insert a new row into emp in database awt1 and select * from emp;    You should see 15 lines.

 3.Logon as scott/tiger at database awt and select * from emp;    You should see 14 lines.
   Now, do a select * from scott.emp_at_awt1, you shall see 15 lines.

 4. To do the insert, update, delete follow the same way as query it!!

Allan W. Tham
DBA Received on Fri Sep 07 2001 - 10:52:03 CEST

Original text of this message