Re: how to create a database link

In our last gripping episode ouaatchane76_at_my-deja.com wrote:
> Hi,
> how cani dreate a database link from another database by using
 sqlplus.
> thanks.
>
> Sent via Deja.com
> http://www.deja.com/
>

This is covered quite well in the documentation. Nonetheless:

create [public] database link <linkname> connect to <username> identified by <password> using <connect string>;

Using Oracle Names the linkname must be the same as the connect string or you will receive an error message.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/