Home » Server Options » Replication » Unable to create a materialized view...with fast refresh
Unable to create a materialized view...with fast refresh [message #7659] Fri, 27 June 2003 10:16
Raj
Messages: 411
Registered: November 1998
Senior Member
Hi

I am unable to create a 'materialized view with fast refresh'. So I created with 'refresh complete'. Later when I use refresh fast it gives me ORA-12018 + ORA-00904 error.

I have tried using FLUSH SHARED_POOL also.

It is very urgent, if you have any idea, please lemme know soon.

thanks,
mrrj@hotmail.com
Previous Topic: Materialized View without triggers?
Next Topic: refreshing snapshot with unique index
Goto Forum:
  


Current Time: Tue Sep 28 21:32:54 CDT 2021