Rem drv: <migrate type="schema_upgrade" version="10.2.0.4"/>
Rem
Rem $Header: failover_schema_upgrade.sql 26-jul-2007.21:59:32 sradhakr Exp $
Rem
Rem failover_schema_upgrade.sql
Rem
Rem Copyright (c) 2007, Oracle.  All rights reserved.  
Rem
Rem    NAME
Rem      failover_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    sradhakr    05/20/07 - Created
Rem

-- Fix for Bug#5873907 starts
DECLARE
 l_sql_stmt VARCHAR2(128);
 l_count NUMBER;
 BEGIN
   -- check if we already have this column added
   SELECT COUNT(*) INTO l_count FROM COL WHERE TNAME='MGMT_FAILOVER_TABLE' AND CNAME='LAST_TIME_STAMP_UTC';
   IF l_count=0 THEN
       l_sql_stmt := 'ALTER TABLE MGMT_FAILOVER_TABLE ADD last_time_stamp_utc TIMESTAMP  DEFAULT sys_extract_utc(SYSTIMESTAMP)';
      EXECUTE IMMEDIATE l_sql_stmt;
   END IF;
 END;
/
-- Fix for Bug#5873907 ends