Rem drv: <migrate type="schema_upgrade" version="10.2.0.0" pos="policy/policy_schema_upgrade.sql+"/>
Rem
Rem $Header: ping_schema_upgrade.sql 03-aug-2005.00:21:47 pmodi Exp $
Rem
Rem ping_schema_upgrade.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      ping_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    pmodi       08/03/05 - Bug:4527456 - Move code for ping_upgrade_4397891  
Rem                           to v102020 
Rem    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the <migration> header 
Rem    rpinnama    06/06/05 - Add upgrade for bug 4397891 
Rem    rpinnama    01/21/05 - rpinnama_bug-4069628
Rem    rpinnama    12/21/04 - Created
Rem


-- These columns might have been added as part of a one-off patch
-- So, check before adding them.
DECLARE
  l_ignore VARCHAR2(64);
BEGIN

  BEGIN
    SELECT column_name INTO l_ignore
      FROM all_tab_columns
     WHERE owner = '&&EM_REPOS_USER'
       AND table_name = 'MGMT_EMD_PING'
       AND column_name = 'PING_JOB_NAME';

  EXCEPTION
    WHEN NO_DATA_FOUND THEN
      EXECUTE IMMEDIATE
        'ALTER TABLE MGMT_EMD_PING ADD (
           ping_job_name          VARCHAR2(64)   DEFAULT NULL,
           job_submit_time        DATE           DEFAULT NULL
         )';
  END;

END;
/