Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\ecm\available

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\ecm\available_searches.sql

Rem
Rem $Header: available_searches.sql 17-dec-2004.11:55:45 xshen Exp $
Rem
Rem available_searches.sql
Rem
Rem Copyright (c) 2003, 2004, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      available_searches.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem      xshen 12/17/04 - changing available searches registry 
Rem      araga 10/26/04 - 
Rem      araga 10/26/04 - 
Rem      araga 10/15/04 - 
Rem      araga 10/11/04 - Now every Integrator SearchPage Object is 
Rem                       implementing Available searches interface.This 
Rem                       approach is cleaner than the earlier huge 
Rem                       switch-case approach. 
Rem      agor  08/02/04 - use plsql block to insert 
Rem      agor  07/28/04 - agor_search_intg_backend
Rem      agor  07/26/04 - Created: Integrators integrate their searches
Rem

SET DEFINE OFF

BEGIN
-- Remove existing registered searches
  DELETE FROM MGMT_AVAILABLE_SEARCHES;
  commit;
      
-- Host Related Searches --
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.OracleProductsSearchPage','ORACLE_PRODUCTS');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.OSRegisteredCompSearchPage','OSREGSW');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.InstalledPatchSetsSearchPage','PATCHSETS_INSTALLED');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.InstalledOSComponentsSearchPage','OSCOMPONENTS');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.InstalledOSPatchesSearchPage','OSPATCHES');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.OSPropertySettingsSearchPage','OSPROPERTYSETTINGS');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.OSPropertyChangesSearchPage','OSPROPERTYCHANGES');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.OSandHWSummariesSearchPage','HARDWARESUMMARIES');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.NICConfSearchPage','NICCONFIGS');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('host', 'oracle.sysman.eml.ecm.search.FileSystemsSearchPage','FSYSTEMS');

-- Begin Database Searches ---------------------------------------------------
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('oracle_database', 'oracle.sysman.db.rprt.search.InitializationParameterSearchPage','initParams');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('oracle_database', 'oracle.sysman.db.rprt.search.InitializationParameterChangeSearchPage','initParamsDelta');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('oracle_database', 'oracle.sysman.db.rprt.search.TablespaceSearchPage','tbsp');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('oracle_database', 'oracle.sysman.db.rprt.search.DatafileSearchPage','datafile');
  ECM_UTIL.INSERT_AVAIL_SEARCHES ('oracle_database', 'oracle.sysman.db.rprt.search.FeatureUsageSearchPage','featureUsage');
-- End Database Available Searches -------------------------------------------

END;
/

COMMIT;

SET DEFINE ON

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de