select * from v$option
and you will *exactly* know what is avaible in PE and what isn't. PE is more
than Standard and less than Enterprise.
Regards
--
Sybrand Bakker
Senior Oracle DBA
to reply remove '-verwijderdit' from my e-mail address
"FC" <flavio_at_tin.it> wrote in message
news:Vw7B8.5453$zW3.143172_at_news1.tin.it...
> 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" <kennedy-family_at_attbi.com> wrote in message
> news:bn_A8.62072$vX.4421_at_rwcrnsc53...
> > It isn't a full featured version. It has less features than standard
> > edition which has less features than enterprise edition.
> > Jim
> >
> > "FC" <flavio_at_tin.it> wrote in message
> > news:xTXA8.4709$zW3.121291_at_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
> > >
> > >
> > >
> >
> >
>
>
Received on Sun May 05 2002 - 05:58:39 CDT
