SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

materialized view refresh only change data on demand basis

Abdul HalimDec 24 2009 — edited Dec 24 2009

Dears

Is there any option to refresh the materialized view with only change data on demand basis ?

Not refresh the whole Materialized view qurey by DBMS_MVIEW.REFRESH(<mv_name>)
but I want to refresh only change value by DBMS_MVIEW.REFRESH(<mv_name>) .

Regards
Muhammad Abdul Halim

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 21 2010

Added on Dec 24 2009

12 comments

1,246 views