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
nobadfile
nologfile
nodiscardfile
fields(
RECORD_TYPE POSITION(1:1)  CHAR , 
IMSI POSITION(2:16) INTEGER EXTERNAL,
EVENT_DATE POSITION(17:24) DATE  "YYYYMMDD",
DURATION POSITION(25:30) INTEGER EXTERNAL,
VOLUME POSITION(31:34) INTEGER EXTERNAL,
SDR POSITION(35:37) INTEGER EXTERNAL,
EVENT_TIME POSITION(38:43) INTEGER EXTERNAL
))
location ('a.dat')  
);