Is Intermedia in use?
Submitted by dave on Tue, 12/02/2008 - 16:01
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.