Rem drv: <migrate type="schema_upgrade" version="10.2.0.2" />
Rem
Rem $Header: provision_schema_upgrade.sql 12-apr-2006.13:55:12 chyu Exp $
Rem
Rem provision_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      provision_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    chyu        04/12/06 - renaming MGMT_PROVISION_DFLT_IMG_PK to 
Rem                           MGMT_PROV_DEFAULT_IMAGE_PK 
Rem    prayarot    01/25/06 - Created
Rem

DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_STATUS_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_STATUS_PK  rename to MGMT_PROV_TGT_STATUS_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_HARDWARE_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_HARDWARE_PK rename to MGMT_PROV_HARDWARE_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_OPERATION_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_OPERATION_PK  rename to MGMT_PROV_OPERATION_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_ASSIGNMENT_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_ASSIGNMENT_PK rename to MGMT_PROV_ASSIGNMENT_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_BOOTSERVER_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_BOOTSERVER_PK  rename to MGMT_PROV_BOOTSERVER_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_BOOTSERVER_UNIQ'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_BOOTSERVER_UNIQ rename to MGMT_PROV_BOOTSERVER_UNIQ' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_DFLT_IMG_UNIQ'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_DFLT_IMG_UNIQ rename to MGMT_PROV_DEFAULT_IMAGE_UNIQ' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_RPM_REP_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_RPM_REP_PK rename to MGMT_PROV_RPM_REP_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_RPM_REP_UNIQ'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_RPM_REP_UNIQ rename to MGMT_PROV_RPM_REP_UNIQ' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_STAGING_DIRECTORIES_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_STAGING_DIRECTORIES_PK rename to MGMT_PROV_STAGING_DIRS_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_STAGING_DIRECTORIES_UNIQ'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_STAGING_DIRECTORIES_UNIQ rename to MGMT_PROV_STAGING_DIRS_UNIQ' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_NET_CONFIG_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_NET_CONFIG_PK rename to MGMT_PROV_NET_CONFIG_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_NET_CONFIG_UK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_NET_CONFIG_UK rename to MGMT_PROV_NET_CONFIG_UK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RANGE_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RANGE_PK rename to MGMT_PROV_IP_RANGE_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RANGE_FK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RANGE_FK rename to MGMT_PROV_IP_RANGE_FK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RANGE_POS'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RANGE_POS rename to MGMT_PROV_IP_RANGE_POS' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RESERVED_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RESERVED_PK rename to MGMT_PROV_IP_RESERVED_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RESERVED_FK1'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RESERVED_FK1 rename to MGMT_PROV_IP_RESERVED_FK1' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISON_IP_RESERVED_FK2'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISON_IP_RESERVED_FK2 rename to MGMT_PROV_IP_RESERVED_FK2' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/
DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_IP_RESERVED_UNQ'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_IP_RESERVED_UNQ rename to MGMT_PROV_IP_RESERVED_UNQ' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/

DECLARE
   l_object_name VARCHAR2(30);
BEGIN
  SELECT object_name
        INTO l_object_name
    FROM all_objects
   WHERE object_name = 'MGMT_PROVISION_DFLT_IMG_PK'
     AND object_type = 'INDEX';

   EXECUTE IMMEDIATE 'alter index MGMT_PROVISION_DFLT_IMG_PK rename to MGMT_PROV_DEFAULT_IMAGE_PK' ;

EXCEPTION
  WHEN NO_DATA_FOUND THEN
   NULL;
END;
/