Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    369

    Unanswered: DBMS_OLAP.RECOMMEND_MVIEW question

    I need help with using the DBMS_OLAP.RECOMMEND_MVIEW package. Here is
    what I have:

    BEGIN
    EXEC DBMS_OLAP.RECOMMEND_MV(fact_table_filter=>'FT1',st orage_in_bytes=>100000,
    retention_list=>'mview1.log',retention_pct=>10);
    END;
    /

    It does not work. For Oracle 8i. what I am doing wrong here? The Oracle 8i package reference has no examples. Just syntax.

    Scott

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    You are checking the wrong manual, use the following link.


    http://download-west.oracle.com/docs...l2.htm#1001435
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    May 2003
    Posts
    369

    extproc not working

    I found the root cause- extproc is not working which is why my DBMS_OLAP did not work. I need to setup extproc.

    Scott

Posting Permissions

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