Re: PL/SQL Supplied packages availability

On 23 May 2006 10:07:27 -0700, djspira_at_hotmail.com wrote:

>Hi,
>
>I have a question about supplied packages with different versions of
>Oracle. Do these vary?
>

Possibly, as many packages support features and options and not all are available in all editions.

>If for I example I do a
>
>Select * from v$option, the online redefinition package is available in
>Oracle 9iR2 (Enterprise) version.
>
>doing a select * from product_component_version where Product like
>'Oracle%'
>
>But if I have a machine that has just Oracle 9i (returned from the
>above query) as the product name the online redefinition feature is
>marked as unavailable (FALSE) (even though we were able to grant
>EXECUTE on DBMS_REDEFINITION.

So this would be the Standard Edition. The Standard Edition definitely has less features. The matrix outlining them is available in the Oracle 9i product family document.

>
>My question therefore is does this vary between versions (eg. the
>feature is only available to the enterprise version) - or is there an
>install option that has not been set?
>
>or thirdly can you switch the feature on?
>
>We've used the feature sucessfully on the machine that reports that it
>is a Oracle 9i Enterprise Edition.
>
>Any advice is much appreciated.
>
>Kind Regards
>
>Rich

--
Sybrand Bakker, Senior Oracle DBA