Re: Error looking up remote object

It seems the table you think you are referring to is not a table at all but a synonym that (eventually) points to an object in a different database.
Could you check dba_objects and see what object_type the object has that has the same name as your table? If you find this is a synonym you should be able to find in DBA_SYNONYMS if the DB_LINK column has a value. If so, your 'table_name' isa synonym pointing to a remote database.

Jaap.

On Wed, 16 Jan 2002 02:26:03 GMT, jfischer_at_insight.rr.com (Joe Fischer) wrote:

> I have Oracle 8i Personal Edition installed on a Windows 2000
>box. There is a table that I'm trying to remove. There is also a
>primary key in a different table that I'm trying to remove. Both of
>these attempts produce the following: "ORA-04052: error occurred when
>looking up remote object." Sometimes it displays some unprintable
>characters right after the message.
> What kind of remote object is this referring to? I did not
>define any.
> Thanks.
Received on Wed Jan 16 2002 - 17:37:56 CST