OraFAQ Forum: Replication » Refresh Matrial View for select rows

Home » Server Options » Replication » Refresh Matrial View for select rows (Oracle 11g R2)

Tue, 14 January 2014 23:35

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?

Tue, 14 January 2014 23:41

BlackSwan
Messages: 26757
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/

Wed, 15 January 2014 01:25

Michel Cadot
Messages: 67648
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: Wed Jan 20 14:41:04 CST 2021