Rem drv: <migrate type="schema_upgrade" version="10.2.0.1"/>
Rem $Header: license_schema_upgrade.sql 01-aug-2007.03:17:53 paachary Exp $
Rem
Rem license_schema_upgrade.sql
Rem
Rem Copyright (c) 2005, 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      license_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    paachary    08/01/07 - Adding the CASCADE DROP INDEX clause in the DROP
Rem                           CONSTRAINT stmt
Rem    paachary    09/22/05 - paachary_bug-4610525
Rem    sdantkal    09/19/05 - Creating a new temporary table to hold 
Rem                            values of mgmt_admin_licenses prior to beta-upgrade.
Rem    paachary    09/16/05 - Created
Rem

SET ECHO ON

DECLARE
    l_count NUMBER := 0;
BEGIN
    SELECT count(*)
    INTO   l_count
    FROM   all_constraints
    WHERE  lower(constraint_name) = 'mgmt_licnse_defntns_tgttype_fk';

    IF (l_count > 0) THEN
        EXECUTE IMMEDIATE 'ALTER TABLE mgmt_license_definitions 
                           DROP CONSTRAINT mgmt_licnse_defntns_tgttype_fk CASCADE DROP INDEX';
    END IF;

    SELECT count(*)
    INTO   l_count
    FROM   all_constraints
    WHERE  lower(constraint_name) = 'mgmt_lcnsbl_tgt_tps_pktgt_fk';

    IF (l_count > 0) THEN
        EXECUTE IMMEDIATE 'ALTER TABLE mgmt_licensable_target_types 
                           DROP CONSTRAINT mgmt_lcnsbl_tgt_tps_pktgt_fk CASCADE DROP INDEX';
    END IF;
    
    EXECUTE IMMEDIATE 'CREATE TABLE admin_licenses_beta
                       AS SELECT * FROM mgmt_admin_licenses';
END;
/