Rem drv: <migrate type="data_upgrade" version="10.2.0.0" pos="jobs/jobs_data_upgrade.sql+"/>
Rem
Rem $Header: license_data_upgrade.sql 26-jul-2005.19:32:13 chyu Exp $
Rem
Rem license_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      license_data_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      This file calls the post creation script in the miogration path to 
Rem      insert the post creation data for license functionality
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        07/26/05 - modifying the migrate header position 
Rem    chyu        07/18/05 - updating the new rep manager header 
Rem    paachary    07/15/05 - Moved the License Granting routine to v102020/license since this was
Rem                           added after the beta cutover.
Rem    bram        05/11/05 - Bug 439108 -Transaction Data-Upgrade to 10.2GC-Prod
Rem    bram        05/11/05 - Bug 4348617 - GC Upgrade: PERFORMANCE TAB IS DISABLED IN GC 
Rem    paachary    03/08/05 - paachary_upgrdscrpts
Rem    paachary    03/03/05 - Created
Rem
--Create temporary tables containing the list of packs enabled(licensed_packs_1014)
--and list of licensed packs(all_packs_1014) in the previous version(10.1.0.4) before executing
--the post creation script for the new version(10.2)


BEGIN
    execute immediate 'create table all_packs_1014 as select distinct pack_label from mgmt_license_definitions'; 
    execute immediate 'create table licensed_packs_1014 as select distinct pack_name from mgmt_admin_licenses'; 
END;
/

@&EM_SQL_ROOT/core/v102010/license/license_post_creation.sql