Hello everyone
Is it possible to get FME to check the last refresh date of a materialized view in Oracle, so we could then get it to send out notification if any haven't been refreshed in a certain period?
Userlevel 4
- 8170 replies
-
11 July 2018
Try something like the following in an SQLExecutor or SQLCreator:
SELECT
OWNER,
MVIEW_NAME,
to_char(last_refresh_date, 'yyyymmddhh24miss') LAST_REFRESH_DATE
FROM all_mviews
WHERE owner = 'MY_OWNER_NAME'
AND mview_name = 'MY_MATERIALIZED_VIEW_NAME'
Expose the attributes
- OWNER
- MVIEW_NAME
- LAST_REFRESH_DATE
The output attribute "LAST_REFRESH_DATE" will contain a timestamp formatted for use in FME with e.g. the DateTimeConverter etc.
Excellent thanks @david_r - will have a look at this, see what we can do.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.