| Database link or Service Name [message #62674] |
Mon, 09 August 2004 01:59  |
Pratap Zope
Messages: 23
Registered: July 2004
|
Junior Member |
|
|
Hi,
if i want to populate table 'a' from database with table 'b' from remote database what will be the difference if I use database link or just service name as connect descriptor (after configuring naming method)?
which is better method?
Please suggest.
Thanks,
Pratap
|
|
|
|
| Re: Database link or Service Name [message #62685 is a reply to message #62674] |
Mon, 09 August 2004 10:22  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Using the db link is the usual way to connect from one database to another. I'm not sure what you mean by using the service name. The DB link is often in the form of:
From A
-----
create database link B connect to scott identified by tiger using 'b';
or
create database link B@SCOTT connect to scott identified by tiger using 'b';
Where "b" is the connect string which corresponds to an entry in the tnsnames.ora file for the oracle home of database A on the server where database A resides. Local naming (tnsnames.ora method) is the usual naming method in most environments.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
