| Linking Database [message #369780] |
Tue, 10 October 2000 14:40  |
rivers
Messages: 4
Registered: October 2000
|
Junior Member |
|
|
|
i need to add some financial information from a separate database. How do i go about linking those so that i can complete an online form?!
|
|
|
|
| Re: Linking Database [message #369781 is a reply to message #369780] |
Tue, 10 October 2000 15:10  |
Rob
Messages: 70
Registered: January 2000
|
Member |
|
|
you need to create a database link
try
create public database link linkname
connect to username identified by PASSWORD
using 'SID';
create public synonym linkname for linkname;
then you can refer to the other db's tables
via
select * from tablename@linkname
verify the link with
select * from dba_db_links
|
|
|
|
| Re: Linking Database [message #369782 is a reply to message #369780] |
Tue, 10 October 2000 15:12 |
Rob
Messages: 70
Registered: January 2000
|
Member |
|
|
you need to create a database link
try
create public database link linkname
connect to username identified by PASSWORD
using 'SID';
create public synonym linkname for linkname;
then you can refer to the other db's tables
via
select * from tablename@linkname
verify the link with
select * from dba_db_links
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
