DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Where Oracle Log the history of mv refreshing

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433

    Where Oracle Log the history of mv refreshing

    Does Oracle Keep all the history of MV refreshing time including failure etc.
    My MV refresh everyday
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    DBA_MVIEWS should give you what you need

  3. #3
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Here for the documentation on the view:
    http://download-west.oracle.com/docs...86.htm#1296735

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width