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

Thread: UTLXMV.SQL

  1. #1
    Join Date
    Nov 2000
    Posts
    178
    Hello Moderators,

    Can anyone direct me to where I can find UTLXMV.sql please? This script is supposed to be in the admin directory but I simply can't find it or is there anything I'm not doing right?

    Ac

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Unhappy


    i don't think it exists. at least not in 8i

    what do you believe this script does?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What is it supposed to do?
    Jeff Hunter

  4. #4
    Join Date
    Nov 2000
    Posts
    178
    Thanks for the reply.
    A procedure DBMS_MVIEW.EXPLAIN_MVIEW, enables you to learn what is possible with a materialized view or potential materialized view. For example, you can determine if a materialized view is fast refreshable and what types of query rewrite you can perform with a perticular materialized view.

    You need to run UTLXMV.sql script prior to calling EXPLAIN_MVIEW.

    Ac

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