Rem drv: <migrate type="schema_upgrade" version="11.1.0.7" condition="EM_REPOS_MODE=SYSAUX" />
Rem $Header: overview_schema_upgrade.sql 14-may-2008.09:36:58 nachen Exp $
Rem
Rem overview_schema_upgrade.sql
Rem
Rem Copyright (c) 2008, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      overview_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    nachen      05/08/08 - Created
Rem
DECLARE
  l_cnt NUMBER := 0;
BEGIN
 IF ('&EM_REPOS_MODE' = 'SYSAUX') THEN

   BEGIN
     select count(*) into l_cnt 
       from all_objects 
      where object_name = 'MGMT_DATABASE_OVERVIEW' 
        and object_type = 'PACKAGE'
        and owner       = '&&EM_REPOS_USER';
   EXCEPTION WHEN OTHERS THEN NULL;
   END;   

   IF (l_cnt = 1) THEN
	execute immediate 'drop package mgmt_database_overview';
   END IF;
 END IF;
END;
/