Re: DB Links

From: Kenneth C Stahl <kstahl_at_lucent.com>
Date: Tue, 22 Jun 1999 08:30:13 -0400
Message-ID: <376F81D4.9EBCD4A3@lucent.com>

If the name of the link is 'experiment' then the syntax is:

select *
from contract_at_experiment

However, I would suggest that if all possible you use schema manager to create your links. If you had, you would have provided the 'experiment' portion and schema manager would have added 'world' so it would become 'experiment.world'.

Also, when you create the name you have to be sure that the service name given is in your tnsnames.ora file.

Ken

"Richard C. Lee" wrote:

> What is the correct syntax for querying a table using a DB link?
> Is it [TableName]@[LinkName]? I've tried this and it hasn't worked.
>
> example: Link name is 'experiment'.
> query: select *
> from contract_at_experiment.prod2
>
> Thanks.
>
> RCL
Received on Tue Jun 22 1999 - 07:30:13 CDT