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?
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.