Re: remote query

I believe you do not have ORACLE distributed option. It is required for database links. You can check it by select * from v$option.

Solomon.Yakobson_at_entex.com
P.S. Check databases on both sides.

In article <32E5F154.747_at_singnet.com.sg>,   Wonderland <Wonderland_at_singnet.com.sg> wrote:
>
> Hi all,
> 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 ?
> Thank you.
>
> Ruyi.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet