Re: ora 04052 & ORA 04029

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 08 Jul 1999 20:56:39 GMT
Message-ID: <378b105d.30350782@inet16.us.oracle.com>

On Thu, 08 Jul 1999 20:40:46 GMT, sanjayraj6844_at_my-deja.com wrote:

>Any body knows how to fix this error
>
>ORA-04052: error occurred when looking up remote object
>USERNAME.TABLENAME_at_SF3.WORLD
>ORA-04029: error ORA-904 occurred when querying
>ORA_KGLR7_IDL_SB4_at_SF3.WORLD
>ORA-00604: error occurred at recursive SQL level 1
>ORA-00904: invalid column name

does this help???

--> oerr ora 4052
04052, 00000, "error occurred when looking up remote object %s%s%s%s%s"

// *Cause:  An error has occurred when trying to look up a remote object.
// *Action: Fix the error.  Make sure the remote database system has run
//          KGLR.SQL to create necessary views used for querying/looking up
//          objects stored in the database.

chris.

>
>
>Thanks in advance
>
>Running
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 08 1999 - 15:56:39 CDT