Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/downgrade/cell_schema_downgrade.sql /st_emdbsa_11.2/1 2008/12/05 20:46:20 ysun Exp $
Rem
Rem cell_schema_downgrade.sql
Rem
Rem Copyright (c) 2008, Oracle and/or its affiliates.All rights reserved. 
Rem
Rem    NAME
Rem      cell_schema_downgrade.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    ysun        11/17/08 - adding the toplevel downgrade for CELL
Rem    ysun        11/17/08 - Created
Rem

define CURR_VER                       = "&1"
define PREV_VER                       = "&2"

Rem Select downgrade script to run
Rem
COLUMN :script_name NEW_VALUE cell_schema_downgrade NOPRINT
VARIABLE script_name VARCHAR2(256)
BEGIN
     IF '&CURR_VER' = '0.0.0.0.0'  OR
        '&PREV_VER' = '0.0.0.0.0'
     THEN
        :script_name := '&EM_SQL_ROOT/core/latest/admin/admin_do_nothing.sql';
     ELSE
        :script_name := '&EM_SQL_ROOT/db/downgrade/cell/' ||  'cell_schema_downgrade' || '_' || '&CURR_VER' || '_' || '&PREV_VER' || '.sql';
     END IF;
END;
/
SELECT :script_name FROM DUAL;
@&cell_schema_downgrade