Home » Server Options » Replication » Refresh Matrial View for select rows (Oracle 11g R2)
Refresh Matrial View for select rows [message #605802] Tue, 14 January 2014 23:35 Go to next message
mokarem
Messages: 109
Registered: November 2013
Location: Dhaka
Senior Member

Hi

I have created materialized view as below

CREATE MATERIALIZED VIEW mv_emp1
REFRESH FAST
AS SELECT * FROM emp WHERE deptno IN (10,20,30)


Now using DBMS_MVIEW.REFRESH, I can refresh the mv_emp1.

Can I refresh this mv_emp1 for deptno 10 only? If not, how can I achieve this?

Re: Refresh Matrial View for select rows [message #605803 is a reply to message #605802] Tue, 14 January 2014 23:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Refresh Matrial View for select rows [message #605808 is a reply to message #605802] Wed, 15 January 2014 01:25 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No you cannot.
Create a mview for each department and a view to union them.

Previous Topic: direct path load and mview refresh
Next Topic: Golden gate monitoring script for struck processess
Goto Forum:
  


Current Time: Thu Mar 28 09:59:03 CDT 2024