2 Replies Latest reply: Aug 12, 2005 9:07 AM by 398072 RSS

    ORA-04052 creating Materialized View

    398072
      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 !!