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 the difference between 10g OEM and 11g OEM?
How to define an anonymous block?
Are truncate and delete commands same? If so why?
How will you identify oracle database software release?
What is the maximum number of triggers that can be applied to a single table?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
What is define in oracle?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
What is using clause and give example?
difference between bind variable and variable
How to convert characters to numbers in oracle?