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?
Question
Check last refresh date of Oracle Materialized Views
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
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.