Re: DB Links

From: Richard C. Lee <rcl4_at_mindspring.com>
Date: Tue, 22 Jun 1999 09:43:52 -0400
Message-ID: <376F9317.1DD5D119@mindspring.com>

Thanks for everyones' help.

I created the DB link using TOAD (Tool for Oracle Application Developers).
Toad seems to create a link named [given name].prod2. I checked the tnsnames file and the entry is not there. I add the entry but it still doesn't work. Then I use the same name for the link as I have in the tnsnames entry and it still doesn't work. TOAD appends something other than ".world" to the name. I don't know why it does this.

I'm going to try using SQL Plus instead of TOAD.

RCL "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 - 08:43:52 CDT