OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » database links

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database links [message #147516]

Fri, 18 November 2005 00:45

bsubbu
Messages: 42
Registered: November 2005
Location: Hyderabad

Member

Hi all
Can anybody please tell me the
Basic description about Database Links with some examples

Bye
Subbu

Report message to a moderator

Re: database links [message #147532 is a reply to message #147516]

Fri, 18 November 2005 02:09

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

Try the SQL Reference Guide - it contains an excellent description of DB Links with some very good examples. Everything you need plus more...

Best regards.

Frank

Report message to a moderator

Re: database links [message #147542 is a reply to message #147532]

Fri, 18 November 2005 02:44

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

why you are posting the same question on the different forum when its already answered.

see your previour post

http://www.orafaq.com/forum/m/145839/72347/?srch=database+links#msg_145839

one specific link from all those

http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/toc.htm

[Updated on: Fri, 18 November 2005 02:48]

Report message to a moderator

Re: database links [message #147604 is a reply to message #147516]

Fri, 18 November 2005 08:55

ramsat
Messages: 49
Registered: November 2005

Member

Hai say for eg u have 2 Db one North and another south

say r the admin of North and if u want to access the details of a schema 'user1' available in south then this is the way

sql> create database link mylinik
connect to user1 identified by passwd
using south;

now say user1 has atable called employye in south database then

sql> select * from employees@mylink;

In case of any problem hit my mailid ramesh_g@kappsoft.com

Report message to a moderator

Previous Topic:	ORA-12570 Packet reader failure after long execution of store procedure
Next Topic:	Problem with the connecting string - Needs Help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 01:21:09 CDT 2025