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

Thread: Materialized view

  1. #1
    Join Date
    Jan 2006
    Posts
    21

    Materialized view

    I want to use Materialized view for Datamart. Do we need to create indexes in MV for fast access? Also, how do we do error log if the MV failed in production because of bad data etc. Thanks

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Whether you need indexes or not depends on the size of the MV data set and how it's accessed. Just think of it as a regular table and go through the same thought process as you normally would.

    You would hopefully get an error message if the refresh failed, and the MV would generally be STALE and show a compile_state of NEEDS_COMPILE
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2006
    Posts
    21
    If MV is running in production who is going to get error message. I understand in dev I will get one as I am testing. Is there a way to send all error messages to users that data refresh last night and for which error? That was the question. This kind of ETL tracing I used to do when working with other RDBMS now how it is supported by Oracle MV?

  4. #4
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    what you can do is write one shell script. in which you will call for refresh of whatever MV's you want redirect its o/p to some log file. and in the last of script mail that log file to user who you think should monitor refresh.

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