Re: connect to a remote database

> Use Database links (if your databases are accessible from your network or
> remote access)
>
> CREATE DATABASE LINK EXAMPLE
> CONNECT TO '(the TNSNames.ora connect string)'
> USING USERNAME
> IDENTIFIED BY PASSWORD;
>
> SELECT *
> FROM TABLE_at_EXAMPLE;
>

You have to name your DB-Link object like the global-name of the db you want to connect to.

You get the global name with

select * from global_name

Regards, Stephan
--

Dipl.-Inf. (FH) Stephan Born   | beusen Consulting GmbH
fon: +49 30 549932-17          | Landsberger Allee 392
fax: +49 30 549932-29          | 12681 Berlin
mailto:stephan.born_at_beusen.de  | Germany
---------------------------------------------------------------