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 can we find out the duplicate values in an oracle table?
Design database draw er diagram for a certain scenario ?
What is Reduced List of Values?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How can I get column names from a table in oracle?
How to convert times to characters in oracle?
How to use regular expression in pattern match conditions in oracle?
What is index-organized table in Oracle?
How to connect asp pages to oracle servers?
Describe the types of sub query?
What is the difference between online and offline backups?
Why cursor variables are easier to use than cursors?
What are the most common interview questions on ETL Testing for experience?
How to recover a dropped table in oracle?
Can you drop an index associated with a unique or primary key constraint?