Rem drv: <migrate type="schema_upgrade" version="10.2.0.3"/>
Rem
Rem $Header: patch_tables_alter.sql 02-jan-2008.16:43:55 rrawat Exp $
Rem
Rem patch_tables_alter.sql
Rem
Rem Copyright (c) 2006, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      patch_tables_alter.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    rrawat     10/07/06 - Created
Rem

DECLARE
  l_tab_name VARCHAR2(30);
BEGIN
 BEGIN
    select table_name into l_tab_name from dba_tables where table_name='MGMT_OUI_ARU_MAP';
 EXCEPTION
   WHEN NO_DATA_FOUND THEN
     EXECUTE IMMEDIATE
     'CREATE TABLE MGMT_OUI_ARU_MAP ( ARU_ID NUMBER(10) NOT NULL,OUI_ID NUMBER(10) NOT NULL)';
  END;

END;
/