Rem
Rem $Header: core_schema_upgrade.sql 13-jun-2003.16:09:45 skini Exp $
Rem
Rem core_schema_upgrade.sql
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      core_schema_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      This script provides the schema upgrade from v400 to v401
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    skini       06/13/03 - Add blackout upgrade
Rem    skini       06/05/03 - Add jobs schema upgrade table
Rem    skini       04/28/03 - Add failvoer table
Rem    snakai      04/24/03 - increase postdata and hidden input hint column and type lengths
Rem    dcawley     04/09/03 - Add  notification_schema_upgrade.sql
Rem    shuberma    04/07/03 - Adding the call to the ecm upgrade script
Rem    sgrover     04/04/03 - add basic tables upgrade
Rem    rpinnama    03/21/03 - rpinnama_setup_repos_migration
Rem    rpinnama    03/19/03 - Created
Rem

Rem
Rem Upgrade tables/indexes
@&EM_SQL_ROOT/core/v401/upgrade/basic_tables_schema_upgrade.sql
@&EM_SQL_ROOT/core/v401/upgrade/notification_schema_upgrade.sql
@&EM_SQL_ROOT/core/v401/upgrade/failover_schema_upgrade.sql
@&EM_SQL_ROOT/core/v401/upgrade/jobs_tables_schema_upgrade.sql
@&EM_SQL_ROOT/core/v401/upgrade/blackout_schema_upgrade.sql
@&EM_SQL_ROOT/core/v401/upgrade/beacon_schema_upgrade.sql


Rem
Rem
Rem Upgrade tables/indexes
@&EM_SQL_ROOT/core/v401/upgrade/ecm_schema_upgrade.sql

Rem
Rem Recreate package definitions
Rem
@&EM_SQL_ROOT/core/latest/core_pkgdefs.sql

Rem
Rem Recreate functions
Rem
@&EM_SQL_ROOT/core/latest/core_funcs.sql

Rem
Rem Recreate procedures
Rem
@&EM_SQL_ROOT/core/latest/core_procs.sql

Rem
Rem Recreate triggers
Rem
@&EM_SQL_ROOT/core/latest/core_triggers.sql


Rem
Rem Recreate views
Rem
@&EM_SQL_ROOT/core/latest/core_views.sql


Rem
Rem Recreate package bodies
Rem
@&EM_SQL_ROOT/core/latest/core_pkgbodys.sql