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 are the built-in functions used for sending Parameters to forms ?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
How to drop an existing table in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What is the dynamic sql in oracle?
interview questions with answer for cts
Can we store pictures in the database and if so, how it can be done?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How do I manually uninstall oracle client?
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
How to rebuild an index in oracle?
What is a dynamic performance view in oracle?