DROP TABLE ext_caveats
/
create table ext_caveats
(
  field_1  varchar2(240),
  field_2  varchar2(240),
  field_3  varchar2(240),
  field_4  varchar2(240),
  field_5  varchar2(240),
  field_6  varchar2(4000)
   )  
   ORGANIZATION EXTERNAL
( type oracle_loader
default directory webmip_bulk_load
access parameters
( records delimited by NEWLINE
  READSIZE 10485760
  skip 1
  fields terminated by ',' 
  optionally enclosed BY '"'
  missing field values are null
  (
  field_1,
  field_2,
  field_3,
  field_4,
  field_5,
  field_6 CHAR(2000)
  )
)
location ('CAVEATS.csv')
)
reject limit unlimited
/
