Database DataWarehousing (MOSC)

MOSC Banner

materialized view

edited Jun 19, 2018 3:31PM in Database DataWarehousing (MOSC) 16 commentsAnswered
 i have created a dblink for fetching the data from one server to other.  I have created a materialized view to  select the data through the dblink into a  database. while executing its showing the following error ora-04052 - error occured when  looking up remote object
ora-00604 -  error occured at recurisve sql level 1
ora-03106 -  fatal 2 task communication protocol error
ora-2063   -  preceding line from dblinkname

pl suggest

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