In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
Answer / 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 |
what is difference between cartesian join & cross join even they give same result?
is database gud carrier option??
How to view the tablespaces in the current database?
how to produce numbers from 1 to 10 using dual table
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
How to create a table index in oracle?
Explain the use of constraints option in exp command.
What are a collation and state the different types of collation sensitivity?
How to delete all rows a table in oracle?
What is the simplest tool to run commands on oracle servers?
How to define a data source name (dsn) in odbc manager?
How many types of synonyms in Oracle?