Materialized View

From: The Magnet <art_at_unsu.com>
Date: Thu, 5 May 2011 13:05:15 -0700 (PDT)
Message-ID: <42fa1441-5daf-4cd1-8931-4db27ad32fa5_at_k27g2000pri.googlegroups.com>



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_at_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? Received on Thu May 05 2011 - 15:05:15 CDT

Original text of this message