Re: remote query

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