Home » SQL & PL/SQL » SQL & PL/SQL » db link
db link [message #162736] Mon, 13 March 2006 06:51 Go to next message
manns
Messages: 59
Registered: March 2006
Location: Bangalore
Member

hi
i have to databse of oracle 9i

how can i connect this two databses
and in a single database i have two users
how can i connect this two users

regards,
manju

Re: db link [message #189587 is a reply to message #162736] Fri, 25 August 2006 03:10 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Hi

Look up "database link" in the documentation.

This way You can use the tables in the other database too.

select ... from table1@otherDB

where otherDB is the database link.

Br
Kim
Previous Topic: need help in format
Next Topic: Rollback command
Goto Forum:
  


Current Time: Sat Dec 03 09:56:36 CST 2016

Total time taken to generate the page: 0.06970 seconds