PL/SQL Supplied packages availability

Hi,

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

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.

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 Received on Tue May 23 2006 - 12:07:27 CDT