Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: standard edition question...
I don't suppose there's any way to have enterprise edition run in "standard mode?" sort of like the compatible version paramater?
I think my answer is no, but thought I'd try anyway since it would save me a lot of time to check on this one function.
Thanks
In article <93mrnm$33h$1_at_soap.pipex.net>,
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
> I can't confirm that rank is unavailable. However anything which
relies on
> query rewrite (which is a surprising amount) is unavailable in the
standard
> edition. My guess would bbe that this might be how rank is implemented
> behind the scenes.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> <gdas_at_my-deja.com> wrote in message
news:93m1uk$hrj$1_at_nnrp1.deja.com...
> > Is anyone running Oracle 8.1.6 standard edition?
> >
> > I found a document on oracle's web site that was explaining the
various
> > differences between 8.1.6 enterprise, personal and standard
editions...
> >
> > One thing that caught my eye was that it said that there are certain
> > sql functions like rank which are only available in Enterprise
Edition.
> >
> > Right now we are doing development in Enterprise Edition because we
> > have a development license. Due to the fact that enterprise edition
> > costs so much more and that we won't be taking advantage of it's
high
> > availability features, we will probably deploy on Standard Edition.
> > And we've been trying to make sure not to use any features specific
to
> > Enterprise Edition.
> >
> > I'm sort of suprised that sql functions would be turned on/off in
the
> > flavors of the database. Especially since Oracle worked with IBM on
> > the analytical functions and that they have been submitted for
> > inclusion as part of the SQL standard.
> >
> > Can anyone who runs standard edition on 8.1.6 or later confirm that
the
> > rank function is disabled?
> >
> > Thanks for your time.
> > Gavin
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
Sent via Deja.com
http://www.deja.com/
Received on Fri Jan 12 2001 - 11:27:34 CST