Re: Select a from remote table

In oder to link to a remote database your firstly need to create the database link.
I think you have conquered this but then to conect to a table on a remote database you would use the following :

select * from user_table_at_remote_domain - This will give you the data from the remote table user_tables

select * from user_tables - This will then give you the data from the currect database.

Rolf Hauck wrote in message <35EE66C7.CBDF17B3_at_datenrevision.de>...
>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 Wed Sep 09 1998 - 14:13:15 CDT