create or replace directory xtern_data_dir  as '/arbor1/arbor/Rohit/';

CREATE  TABLE XTERN_DIALOG_CDR_OUTCOLLECT
(
  RECORD_TYPE  CHAR(1),
  IMSI         NUMBER(15),
  EVENT_DATE   DATE,
  DURATION     NUMBER(7),
  VOLUME       NUMBER(20),
  SDR          NUMBER(12),
  EVENT_TIME   NUMBER(6)
)
organization external
(default directory xtern_data_dir
access parameters
(
records delimited by newline
badfile 'dave.bad'
logfile 'dave.log'
fields(
RECORD_TYPE POSITION(1:1), 
IMSI POSITION(2:16) ,
EVENT_DATE POSITION(17:24) DATE_FORMAT DATE "YYYYMMDD",
DURATION POSITION(25:30) ,
VOLUME POSITION(31:34) ,
SDR POSITION(35:37) ,
EVENT_TIME POSITION(38:43)
))
location ('a.dat')  
);