Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ora 04052 & ORA 04029
Cannot find KGLR.SQL . Where is it. In $ORACLE_HOME???
In article <378b105d.30350782_at_inet16.us.oracle.com>,
clbeck_at_us.oracle.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Thu Jul 08 1999 - 22:22:48 CDT