Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.cvns.net!not-for-mail
From: "CVNS" <tmartin@cvns.net>
Newsgroups: comp.databases.oracle.server
Subject: DBMS_OLAP RECOMMEND DOESN'T SEEM TO WORK.
Date: Sat, 2 Feb 2002 20:04:19 -0500
Organization: Cumberland Valley Networking Services, Inc.
Lines: 10
Message-ID: <a3i827$3np$1@news.cvns.net>
NNTP-Posting-Host: tmartin.cvns.net
X-Trace: news.cvns.net 1012704135 3833 205.216.38.96 (3 Feb 2002 02:42:15 GMT)
X-Complaints-To: usenet@news.cvns.net
NNTP-Posting-Date: Sun, 3 Feb 2002 02:42:15 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Xref: easynews comp.databases.oracle.server:133704
X-Received-Date: Sat, 02 Feb 2002 19:44:04 MST (news.easynews.com)

When we try to run this package on 9i we keep getting a RPC error. Anyone
been able to get it to work?

DBMS_OLAP.RECOMMEND_MV('fact', 100000, '', 10);

We have built a datawarehouse and now are adding materialized views. The
recommend command is suppose to help you figure out what MView you need. Any
suggestions.