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
- 3541 Views
- I also Faced
- E-Mail Answers
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 relation of a user account and a schema?
What are the factors causing the reparsing of SQL statements in SGA?
How to remove a row in a database table?
Explain the use of indexes option in exp command.
Explain oracle insert into command?
how to do daily transactions with out sql* loader control file regesterd in apps?
How do I find my oracle client driver version?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Why does Oracle not permit the use of PCTUSED with indexes?
what is the output of select * from emp where null=null & select * from emp where 1=1
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
Oracle General 
