In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
Answer Posted / anuradha
USER_MVIEW_REFRESH_TIMES
This dictionary table lists the Materialized views and
their last refresh times for each master table that the
user can look at.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How oracle handles dead locks?
Explain the difference between a procedure and a function?
what are actual and formal parameters?
11. Display the client number and name and the client number and name of the person who referred that client.
What are the built-in functions used for sending Parameters to forms ?
How to export data with a field delimiter?
How to speed up webrick?
What is the difference between view and materialized view in Oracle?
What is max rowid in oracle?
What are the differences between char and varchar2 in oracle?
What is Virtual Private Database in Oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to call a stored function in oracle?
How to list all indexes in your schema?
Is oracle a language?