Home » SQL & PL/SQL » SQL & PL/SQL » Materialized view across network (10.2g)
Materialized view across network [message #355103] Wed, 22 October 2008 12:22 Go to next message
Messages: 49
Registered: August 2008
SQL> create materialized view mv_tab
  2  TABLESPACE test_mv
  3  REFRESH FAST on commit
  4  WITH rowid
  5  As select a,b
  6  c,d
  7  from tab_test@db11 where upper(IS_TEST)='Y';
from tab_test@db11 where upper(IS_TEST)='Y'
ERROR at line 7:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

My demand is to refresh materialized view after commit on network link. How can I achieve?
Re: Materialized view across network [message #431262 is a reply to message #355103] Mon, 16 November 2009 06:34 Go to previous message
Messages: 11
Registered: November 2009
Location: Singapore
Junior Member
You can't refresh a materialized view ON COMMIT when it selects across a dblink. Your database doesn't know about commits taking place in the remote database!

Please check on http<DOT>://download-west.oracle.com/docs/cd/B10501_01/server.920/a96567/toc.htm
Next Topic: Creating a procedure to close cursors
Goto Forum:

Current Time: Wed Aug 16 08:28:28 CDT 2017

Total time taken to generate the page: 0.13892 seconds