Skip to Main Content

Oracle Database Discussions

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!

Periodic refresh of Materialized View

Jura ThimaOct 10 2013 — edited Oct 22 2013

Hi,

I am working in a Oracle database for Oracle E-Business Suite.

In the database we have a custom materialized view defined as follow:

CREATE MATERIALIZED VIEW APPS.XXCUS_NAME_MV

<...>

BUILD IMMEDIATE

REFRESH FORCE ON DEMAND

<....>

From the below SQL I learn that the MV was refreshed during the night, I assume this is every night since i have executed the query for the last several days.

SELECT OWNER, MVIEW_NAME, LAST_REFRESH_DATE, REFRESH_METHOD, REFRESH_MODE, BUILD_MODE

FROM DBA_MVIEWS

WHERE MVIEW_NAME LIKE 'XXCUS_NAME_MV%'

APPSXXCUS_NAME_MV10-10-2013 2:00:14FORCEDEMANDIMMEDIATE

However, I cannot find anywhere how this refresh is scheduled by means of a job?

I tried below query but there are no scheduled jobs forĀ  DBMS_REFRESH.REFRESH or DBMS_MVIEW.REFRESH.

SELECT * FROM DBA_JOBS;

Does anyone has an idea how the MV is refreshed automatically (periodically) other tahn by jobs?

Thx!

This post has been answered by Hemant K Chitale on Oct 10 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2013
Added on Oct 10 2013
4 comments
685 views