Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DB Links

DB Links

From: Richard C. Lee <rcl4_at_mindspring.com>
Date: Mon, 21 Jun 1999 17:41:42 -0400
Message-ID: <376EB196.9A2F2F80@mindspring.com>


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 Mon Jun 21 1999 - 16:41:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US