create table test_ext(
 sdate date,  
 rtime timestamp with time zone,
)
organization external(
    type oracle_loader
    default directory datadir
    access parameters
    (
      records delimited by newline
      fields terminated by ';'
      missing field values are null
   (
  sdate date "YYYY-MM-DD HH24:MI:SS",  
  rtime char(35) date_format TIMESTAMP WITH TIMEZONE mask "YYYY-MM-DD HH.MI.SS.FFTZH"
)
    )
    location ('test_extra.csv')
)
parallel 4 reject limit unlimited;

 

test_extra.csv

2012-04-26;2012-04-27 09:18:00.327238+08
2012-08-02;2012-08-02 12:32:43.271926+08
2012-08-02;2012-08-02 12:33:01.43135+08
2012-08-02;2012-08-02 12:33:06.920191+08