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

spool SYS_RUNTIME_ARCHIVE_CONFIG.log

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

create table SYS_RUNTIME_ARCHIVE_CONFIG
(
  JOB_ID       NUMBER not null,
  INTERVAL_DAY NUMBER not null,
  ARCHIVE_TYPE VARCHAR2(20)
);

spool off

exit
