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,
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