My Oracle Support Banner

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

Last updated on FEBRUARY 21, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.