Re: Refresh Materialized view

Posted by ErmanArslansOracleBlog on Dec 21, 2016; 6:15am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Refresh-Materialized-view-tp1792p1793.html

create a materialized view  "Refresh group".

Put your materialized views in that materialized view Refresh group.

Refresh the Refresh group..

21 Ara 2016 09:24 tarihinde "Arsala saleem [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Sir

I have more then 50 materialized in my Data warehouse which are dblink with production database.

Example

create materialized view MV_VIEWE_NAME  refresh on demand with rowid as select * from

SIGTASAD.TABLE_NAME@dwhsig_link;


so does it possible to refresh all M view in one command. i have found one example kindly verify it.

DECLARE
v_number_of_failures NUMBER(12) := 0;
BEGIN
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_number_of_failures,'F','', TRUE, FALSE);
END;

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Refresh-Materialized-view-tp1792.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML