Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: standard edition question...

Re: standard edition question...

From: <gdas_at_my-deja.com>
Date: Fri, 12 Jan 2001 17:27:34 GMT
Message-ID: <93nepn$mn5$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US