Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-04052 creating Materialized View

398072Jul 22 2005 — edited Aug 12 2005

Hi All !!

I'm trying to create a Materialized view and his query definition uses an active public database link. When I ran the script for creating the view I get the following message:

ERROR in line 1:
ORA-04052: error occurred when looking up remote object
SPOA.DIRECCIONES_FISCALIAS@ORCL2
ORA-00604: error occurred at recursive SQL level 1
ORA-03106: fatal two-task communication protocol error
ORA-02063: preceding line from ORCL2

But when I execute his definition query all is ok, the query works fine. I checked for the GLOBAL_NAMES parameter and it is set to FALSE. Please help me, How can I fix this problem ?

Thanks in advance !!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 9 2005

Added on Jul 22 2005

#general-database-discussions

6 comments

1,298 views