WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
WHENEVER OSERROR  EXIT FAILURE ROLLBACK;

spool SYS_CONFIG_CUSTOMIZATION_HEAD.log

prompt
prompt Creating table SYS_CONFIG_CUSTOMIZATION_HEAD
prompt ====================================
prompt
whenever sqlerror continue
drop table SYS_CONFIG_CUSTOMIZATION_HEAD; 
whenever sqlerror exit failure rollback

-- Create table
create table SYS_CONFIG_CUSTOMIZATION_HEAD
(
  HEAD_ID          NUMBER not null,
  ENABLE_FLAG      VARCHAR2(1) default 'Y',
  COMMENTS         VARCHAR2(2000),
  CREATED_BY       NUMBER not null,
  CREATION_DATE    DATE not null,
  LAST_UPDATED_BY  NUMBER not null,
  LAST_UPDATE_DATE DATE not null
);
-- Create/Recreate primary, unique and foreign key constraints 
alter table SYS_CONFIG_CUSTOMIZATION_HEAD
  add primary key (HEAD_ID)
  using index ;

spool off
exit
