Hi,

Can I do a complete refresh of a materialized view if the view exists
on a remote database? I tried doing it via the db link but the the
famous:

exec DBMS_MVIEW.REFRESH('ecom_orders_mv@engine','C')

ERROR at line 1:
ORA-20000: ORA-00979: illegal reference to remote database
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2255
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2461
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2430
ORA-06512: at line 1

Any thoughts?