Re: Intermedia text ORACLE 8.1.5

Hello Andre,

The name after the "@" is the name of a databaselink. You can either change the SQL-statement (remove the @remote_database) or change the databaselink to point to the database where the table resides.

HTH Berno

Andre Klos schreef:

> Hello Group,
>
> when I execute this SELECT-Statement
>
> SELECT * FROM table_name_at_remote_database WHERE contains (text,
> 'searchstring') > 0
>
> the following error occurs:
>
> ORA-04052 error occurred when looking up remote object
> USER.CTXSYS_at_other_remote_database
>
> The other_remote_database doesn't exist anymore. Can anyone help me for this
> problem?
>
> Thanks
>
> André Klos
Received on Thu Sep 20 2001 - 03:17:50 CDT