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

Home -> Community -> Usenet -> c.d.o.misc -> Re: remote query

Re: remote query

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/26
Message-ID: <32EBEF23.5DBB@qrcsun.qrc.org>#1/1

Wonderland wrote:
>
> I encountered the following problem when executing the following
> query :
>
> SQL> select * from all_users_at_link_to_SID1;
> *
> Error at line 1:
> ORA-00922 : Missing or invalid option
> ORA-02063 : Preceding line from link_to_SID1
>
> Can anyone tell me what went wrong ?

   The database link must match the global database name. So, you can create a database link with the name SID1. Then, you can use select * from all_users_at_SID1 to achieve your purpose.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841
Received on Sun Jan 26 1997 - 00:00:00 CST

Original text of this message

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