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
What the is the diff between local index and global index. give some example.
Differentiate between translate and replace?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain an exception?
Explain the different normalization forms?
Differentiate between pre-select and pre-query?
ABOUT IDENTITY?
Why do you create or replace procedures rather that drop and recreate.
How to convert numbers to characters in oracle?
How to open and close an explicit cursor in oracle?
What are the execution control statements?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Can you assign multiple query result rows to a variable?
How can I see all tables in oracle?
How to convert raw data type into text in oracle? Explain