Interested to Buy Any Domain ? << Click Here >> for more details...
In which dictionary table or view would you look to
determine at which time a snapshot or MVIEW last
successfully refreshed?
- 1 Answers
- 3622 Views
- I also Faced
- E-Mail Answers
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 do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain what are synonyms used for?
Can you tell me how to add new column in existing views?how?How is possible?
Give the constructs of a package, function or a procedure.
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to calculate date and time differences in oracle?
Can we create trigger on materialized view in oracle?
Difference between pre-select and pre-query
Explain an index?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
List out the difference between commit, rollback, and savepoint?
What is the difference between translate and replace in oracle?
How to insert a new row into a table in oracle?
What's dateware house and what's clustor with practicle example
What happens to indexes if you drop a table?
