Refresh materialied view
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:
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
0