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 will you identify oracle database software release?
What is oracle open database communication (odbc)?
How to name query output columns in oracle?
Explain the characteristics of oracle dba?
What are the parameters that we can pass through a stored procedure?
Is there a function to split a string in plsql?
What is a static data dictionary in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How do I escape a reserved word in oracle?
What is a nvl function?
How to drop an existing table in oracle?
Explain an exception and its types?
What is not equal to in oracle?
How to test null values?
WHAT IS ecc 6.0