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%'
APPS | XXCUS_NAME_MV | 10-10-2013 2:00:14 | FORCE | DEMAND | IMMEDIATE |
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!