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>
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