Path: news.easynews.com!easynews!cyclone.swbell.net!cyclone-sf.pbi.net!64.245.249.51!sfo2-feed1.news.algx.net!jfk3-feed1.news.algx.net!allegiance!news.maxwell.syr.edu!news.mailgate.org!news-out.tin.it!news-in.tin.it!news1.tin.it.POSTED!not-for-mail From: "FC" Newsgroups: comp.databases.oracle.misc References: Subject: Re: Missing analytic functions in 8i Personal Ed. for Win98 ??? Lines: 41 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: Date: Sun, 05 May 2002 10:08:53 GMT NNTP-Posting-Host: 212.216.141.233 X-Complaints-To: newsmaster@tin.it X-Trace: news1.tin.it 1020593333 212.216.141.233 (Sun, 05 May 2002 12:08:53 MET DST) NNTP-Posting-Date: Sun, 05 May 2002 12:08:53 MET DST Organization: TIN Xref: easynews comp.databases.oracle.misc:81189 X-Received-Date: Sun, 05 May 2002 03:06:35 MST (news.easynews.com) Does that mean that "somewhere" in the outer space, "someone" wrote that this specific function isn't available ? I mean, there is no trace whatsoever in any of the accompanying manuals of such limitation, unless I overlooked it of course, in that case I would be extremely glad to anybody who shows me where it is located. If I check the SQL Reference manual for version 8.1.5, there is no mention of analytic functions as they have been introduced as of 8.1.7, right? Now, since I installed version 8.1.7 P.E. I'd expect these functions to be there. And it seems very odd to me that Personal Edition differs from Standard because of the absence of analytic functions or, alternatively, I'd expect Oracle to point it out very clearly in the Release Notes. Thanks, Flavio "Jim Kennedy" wrote in message news:bn_A8.62072$vX.4421@rwcrnsc53... > It isn't a full featured version. It has less features than standard > edition which has less features than enterprise edition. > Jim > > "FC" wrote in message > news:xTXA8.4709$zW3.121291@news1.tin.it... > > Folks, > > I just checked the documentation coming with 8i PE for Win98 and I can't > > find any reference to missing features of SQL, so, why am I getting the > > following error when I try to use the rank() function ? > > > > "ORA-00439: feature not enabled: OLAP Window Functions" > > > > Thanks, > > Flavio > > > > > > > >