DB- LINK

[SAJI]

1. Can anybody explain me about db-link


2. i want to connect one database with a remote database, what is the best solution

thanks

[rohitsn]

Hi,
Database Link is basically used in DIstributed Database System where one database want to access the another database.
In order to create a database link make the following parameter to GLOBAL_NAMES=FALSE in init.ora file.This paramter will allow u to create the database link with any name.
Then create an entry in tnsnames.ora file for connect string of the other database.
After creating an entry in tnsnames.ora file enter the following command to check the connection at the DOS prompt
c:\>tnsping

Once the connection is established then create the database link under user SYS through the following command:

sql>create public database link BIGLINK
connect to user1 identified by password
using 'connect_string'

user1 == username on the other database
password= password of the user on the other database
connect_string = connect string of the other
database

So u login as a user and give the follwoing command to access the tables of that user

sql>select * from user1.table_name@biglink;

I hope that I have answered ur question.In case of any help please be free to ask me at rohitsn@altavista.com

Regards,
Rohit nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[julian]

Creating DB links is an issue treated with mistakes even in METALINK (about DB links between DBs running in the same Oracle Parallel Server enviroment). The way you create DB links depends on which version of Oracle you use. The difference is very small but it it exists :-)

rohitsn has explained very well the basic syntax.

Ask here if you have problems after creating the DB links.

[SAJI]

hi, rohitsn


sql>create public database link BIGLINK
connect to user1 identified by password
using 'connect_string'


I created the link using the above statement of yours.
but the connect to user1..... is not working. there is some syntax error

[SANJAY_G]

Can you post the error message?

Sanjay

[Horace]

Hi Sanji,

I assume that when you say you are having problems connecting as user1, you haven't actually typed in 'user1' ?

Obviously, rohitsn meant user1 as an example of the connect string, you should substitute the schema name you are trying to connect to.

[SAJI]

connect to user1 identified by password
using 'connect_string'


i given user1 as my main user
password is of main user password
and the connect string with quotes and with out also


tell me is there any statement like ' connect to .... ' ?

[sprabhakar]

Hi Saji,

Can you post the error that you are receiving so that we can help you ?

S.Prabhakar

[SAJI]

sorry.
it is working fine. i made a mistake of connecting that
thanks to all