1

I have two database users in my Oracle DB and want to create MV's in User B which get their data from User A through a database link.

I plan to autorefresh the MV's every night but want to make sure the MV's are always up to date if something doesn't work with the autorefresh.

I found two kind of meta-data about the MV's: "LAST_REFRESH_TYPE" and "LAST_REFRESH_DATE".

Does the "LAST_REFRESH_DATE" always contain the date when my data was successfully refreshed the last time or just the date when a refresh was started (and perhaps failed)?

  • 1
    Is that column from DBA_MVIEWS? I would think that it would be for a successful refresh. Aside from that, it sounds like your two users are in the same database ("I have two database users in my Oracle DB"). If that is the case, there is no need to use a db_link ("which get their data from User A through a database link."). Why do this with a cron job? Why not a database job? – EdStevens May 23 at 22:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.