PL/SQL (MOSC)

MOSC Banner

Unable To Create mview over dblink

edited Sep 30, 2017 2:53PM in PL/SQL (MOSC) 7 commentsAnswered

I have a developer that is unable to create a materialized view over a dblink.

The creation of a regular view succeeds. This is all Linux x64 12.1.0.2. on the same server. I've had an SR on this for 3 weeks and no working response yet. We are unable to use a public link due to security concerns. This is a private dblink.

I have rerun suggested rdbms/admin script, verified privileges etc.  I have also tried the workaround at the MOS doc on 04052.

This is the error message:

SQL Error: ORA-04052: error occurred when looking up remote object AFMOWN.R_TASK@CJTEST.PSMAG.CGIPDC.CGINET

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center