Ora-04052, ORA-604, ORA-3120 When Creating Materialized View (Doc ID 460946.1)

Last updated on NOVEMBER 24, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 and later   [Release: 10.1 and later ]
Information in this document applies to any platform.
***Checked for relevance on 25-Nov-2011***

Symptoms

When creating materialized view, it fails with ORA-04052, ORA-00604, ORA-03120.
For more details see the next example :

CREATE MATERIALIZED VIEW Test
BUILD IMMEDIATE
REFRESH FORCE WITH PRIMARY KEY
AS
SELECT column1,column2
FROM
testTable@DBlink;

ERROR at line 1:
ORA-04052: error occurred when looking up remote object
BILLING.GENR_DD_TYPES@DBlink
ORA-00604: error occurred at recursive SQL level 1
ORA-03120: two-task conversion routine: integer overflow
ORA-02063: preceding line from DBlink

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms