Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB Links
In article <376EB196.9A2F2F80_at_mindspring.com>,
rcl4_at_cornell.edu 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
>
>
hi, did u create the dblink as public or from a particular user? for
eg. if u created the link from scott, then it becomes a private dblink
for scott only. This could be the reason for the error because the
syntax u use is correct. If u can specify what is the error given, that
will give lot of hint.
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Jun 21 1999 - 19:59:19 CDT