How to check for installed products in Oracle

[jlakhani]

I have to check if partitioning is installed with a specific oracle home. How would I do that? Is there a sql I can run?

Jigar

[millerg]

Jigai,

SELECT * FROM v$option
WHERE name = 'Partitioning'
;

HTH

Gerry

[jlakhani]

Thanks.