|
-
Problem resolved
Hi guys,
It's been a while, but the problem is solved.
I had some assistence, this week, from a Oracle Support guy called Bobby. (I issued a TAR at the metalink-site) He called me from India, because the ODC-connection failed. After a while he gave me the solution:
Hi Erik,
Like I mentioned to you over the phone, this is a known Bug in 8i , which is fixed in 9i.
The Bug number is 1679040.
According to the Bug, both LAST_REFRESH_TYPE and LAST_REFRESH_DATE columns of DBA_MVIEWS / USER_MVIEWS do not get updated.
The LAST_REFRESH column in DBA_SNAPSHOT_REFRESH_TIMES / USER_SNAPSHOT_REFRESH_TIMES does get updated with the last refresh date/time.
However, the last refresh type information is not updated in any view.
Regards,
Bobby
So fast refresh works, but the views display the wrong info.
Thanks go to Bobby for solving the problem and giving Oracle a huge telephone bill
Case closed!
An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|