Is Intermedia in use?

When copying or moving databases it is nice to know if features are used or not. Sure you can always query DBA_REGISTRY to see what has been set up on the source databases, but is it always necessary to install everything that shows up in DBA_REGISTRY on your target systems?

Intermedia is a feature that can be a particular pain to install and configure.

Metalink Note 458123.1 "Script To Check If interMedia Is Being Used In Oracle Version 10.2" includes a script that checks to see if a database is currently using any Intermedia features. The script spits out a simple Yes/No to indicate if Intermedia is in use.

The following notes are for older versions of Oracle:
Note 458140.1 - Script to check if interMedia is being used in Oracle Version 10.1
Note 458141.1 - Script to check if interMedia is being used in Oracle Version 9.2

-Dave

Thanks to Anita S. for passing this helpful hint along.