Home » SQL & PL/SQL » SQL & PL/SQL » Materialzied View on Fast Refresh
Materialzied View on Fast Refresh [message #216950] Wed, 31 January 2007 00:48 Go to next message
rawat_me
Messages: 45
Registered: September 2005
Member
Can in oracle we create a materialized view for REFRESH FAST ON COMMIT for a
Database link.

I have this command:

CREATE MATERIALIZED VIEW Mv_X
REFRESH FAST ON commit
With Rowid
AS SELECT * FROM X@db_link ;

This gives the Oracle Error : ora-12054 error, cannot set on commit refresh attribute for the materialised view

When i changed the Command to


CREATE MATERIALIZED VIEW Mv_X
REFRESH FAST
START WITH SYSDATE
NEXT trunc(sysdate)+1+(1/1244)
with ROWID
AS SELECT * FROM X@db_link ;

It worked fine.

Please help.
Re: Materialzied View on Fast Refresh [message #216962 is a reply to message #216950] Wed, 31 January 2007 01:32 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
No, the ON COMMIT option is only for local MVs.

Ross Leishman
Previous Topic: help for using update query
Next Topic: utl_file write error
Goto Forum:
  


Current Time: Mon Dec 05 09:12:39 CST 2016

Total time taken to generate the page: 0.22150 seconds