Unable To Create mview over dblink
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