Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error looking up remote object
Turns out the problem was caused by the standard package being missing or screwed up. After building that, it works now.
On Wed, 16 Jan 2002 23:37:56 GMT, j.w.vandijk_at_hetnet.nl (Jaap W. van Dijk) wrote:
>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 Fri Jan 18 2002 - 19:00:42 CST