This discussion is archived
2 Replies Latest reply: Aug 12, 2005 7:07 AM by 398072 RSS

ORA-04052 creating Materialized View

398072 Newbie
Currently Being Moderated
ORA-04052 creating Materialized View

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
USER.TABLE@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 mean, I'm using the following sentence to create the view:

CREATE MATERIALIZED VIEW my_view TABLESPACE tbsname BUILD IMMEDIATE
REFRESH FORCE
WITH ROWID
ENABLE QUERY REWRITE
AS
SELECT ...
FROM SCHEMA_NAME.TABLE_NAME@ORCL2;

The above sentence give me ORA-04052. Nevertheless the SELECT... FROM SCHEMA_NAME.TABLE_NAME@ORCL2; works fine...

I checked for the GLOBAL_NAMES parameter and it is set to FALSE. Please help me, How can I fix this problem ?

I'm using Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production running over Win XP for create the view.

The Database Link points to Oracle Database 10g Release 10.1.0.4.0 - 64bit Production running over Solaris

Thanks in advance !!