Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.0/osb/osb_schema_upgrade.sql /st_emdbsa_11.2/2 2009/03/04 19:53:18 swbalasu Exp $
Rem
Rem osb_schema_upgrade.sql
Rem
Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      osb_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem ***********************IMPORTANT NOTE*********************
Rem **  file is hould contain only schema that requires oms **
Rem **  to be shutdown, otherwise update                    **
Rem **  osb_pre_upgrade_schema.sql                          **
Rem ***********************IMPORTANT NOTE*********************
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    swbalasu    03/01/09 - bug 7702321
Rem    swbalasu    10/29/08 - bug 7498153
Rem    pfgavin     09/18/08 - fix 3609137
Rem    swbalasu    07/07/08 - Created
Rem

BEGIN
    execute immediate 'drop table MGMT_OB_ADMIN_HOSTS cascade constraints';
EXCEPTION 
    WHEN OTHERS THEN null;
END;
/

DROP TABLE MGMT_OB_ADMIN_CLIENT_DB CASCADE CONSTRAINTS;

CREATE TABLE MGMT_OB_ADMIN_CLIENT_DB (
  OB_TARGET_GUID         RAW(16) NOT NULL,
  OB_CLIENT_HOST         VARCHAR(128),
  OB_ADMIN_TARGET_GUID   RAW(16) NOT NULL,
  CONSTRAINT MGMT_OB_ADMIN_CLIENT_DB PRIMARY KEY(OB_TARGET_GUID, OB_ADMIN_TARGET_GUID)
) MONITORING;

BEGIN
    execute immediate 'CREATE INDEX MGMT_OB_ADMIN_CLIENT_DB_IX1 on MGMT_OB_ADMIN_CLIENT_DB(OB_ADMIN_TARGET_GUID)';
EXCEPTION
    WHEN OTHERS THEN 
      -- column already indexed
      IF SQLCODE = -1408
      THEN
         NULL;
      END IF;
      -- index name already in use
      IF SQLCODE = -955
      THEN
         NULL;
      END IF;
END;
/