PL/SQL (MOSC)

MOSC Banner

Refresh materialied view

edited Apr 19, 2012 7:43PM in PL/SQL (MOSC) 3 commentsAnswered
Hello,

I have two schemas, a and b,  on the schema b I have a materialized view  with a log,  I need to be able  to refresh it trought a dblink from the schema a to schema b, but  I get the following error:

ORA-20000: ORA-00979: illegal reference to remote database

ORA-06512: en "SYS.DBMS_SNAPSHOT", línea 2254T

What should I do in this case? or is there any better way to do this??

Thanks


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