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 |
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
State any two functions of oracle?
How to create a table in a specific tablespace?
What are the numeric comparison operations?
Explain temporal data types in oracle
State the difference between a primary key and foreign key?
How to use an explicit cursor without open statements?
Where are the settings stored for each instance in oracle?
What is ordinary table in oracle?
What are main difference between Stored Procedure and Functions.
Why is oracle used?
How many types of segments in Oracle?