Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DB link
I've run across this error when the remote DB is a standby database (or
any database, for that matter) which is open read-only. New objects
were created in the source database, and PL/SQL code against the remote
standby database involving these objects were giving this error.
What worked for me (version 8.1.6) was to run the code which gets the error against the source database (read-write) using a temporary DB link, then something internal to Oracle (dictionary) apparently was propagated to the standby database (via normal application of redo logs) and everything worked OK after that.
--Mark B.
Karsten Farrell wrote:
> buro9 wrote:
>
>> we'e currently also getting an ORA-04052: >> ORA-04052: error occurred when looking up remote object >> <objectname removed> >> >> >> it seems a pretty major problem and the only thing i've found so far >> is a proposal to rerun some of Oracles internals... but this results >> in downtime. >> >> has anyone come across this issue and then resolved it without downtime? >> >> cheers >> >> david k