Re: Select a from remote table

My Oracle Documentation (for ORA 7.x) states that the name of the dblink must match the name of the remote database. Are you sure about this?

Rolf

Hong Yew wrote:
>
> We are using Personal Oracle to access a remote Oracle 8 NT server .We can't
> seems to select from a remote table using :
>
> SELECT * FROM username.table_at_remote_dblink;
>
> We have created a database link of with
>
> CREATE DATABASE LINK remote_dblink CONNECT TO username
> IDENTIFIED BY password VALUE 'remote_domain'
>
> We are able to CONNECT to the remote site using
> username/password_at_remote_domain!
>
Received on Thu Sep 03 1998 - 04:52:07 CDT