CREATE TABLE ERS_CERNER_SRC
(
  INSTALLATION_ID          VARCHAR2(50 BYTE)        NULL,
  TRANSACTION_ID           VARCHAR2(50 BYTE)        NULL,
  SERVER_ID                VARCHAR2(50 BYTE)        NULL,
  CLINICAL_TRANSACTION_ID  VARCHAR2(255 BYTE)       NULL,
  RESPONSE_TIME            NUMBER(10,3)             NULL,
  TRANSACTION_START_TIME   TIMESTAMP(9)             NULL,
  TRANSACTION_END_TIME     TIMESTAMP(9)             NULL,
  LOCATION_ID              VARCHAR2(50 BYTE)        NULL,
  FILE_NAME                VARCHAR2(100 BYTE)       NULL,
  STATUS                   VARCHAR2(1 BYTE)         NULL,
  ETL_DATE                 DATE                     NULL
)
PARTITION BY RANGE (ETL_DATE) 
(  
  PARTITION SRCtbl_20130901 VALUES LESS THAN (TO_DATE(' 2013-09-02 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
    LOGGING
    NOCOMPRESS,  
  
  PARTITION SRCTBL_MAXVALUE VALUES LESS THAN (MAXVALUE)
    LOGGING
    NOCOMPRESS
)
NOCOMPRESS 
NOCACHE
NOPARALLEL
MONITORING
ENABLE ROW MOVEMENT;

CREATE INDEX ETL_SRC.ERS_CERNER_SRC_IDX ON ERS_CERNER_SRC
(INSTALLATION_ID, CLINICAL_TRANSACTION_ID, LOCATION_ID)
LOGGING
NOPARALLEL;

        OPTIONS (DIRECT=true,ERRORS=9999999, SILENT=(HEADER,FEEDBACK))
        load data
        BADFILE '/ersdg3/ERS/ERS_INPUT_LOGS/CERNER/badfiles/DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv'
        DISCARDFILE '/ersdg3/ERS/ERS_INPUT_LOGS/CERNER/discardfiles/SRC_102_16_15_00.csv'
        append into table ERS_CERNER_SRC
        FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
        TRAILING NULLCOLS
        (FILLER1 BOUNDFILLER TERMINATED BY ',' ,
        FILLER2 BOUNDFILLER TERMINATED BY ',' ,
        SERVER_ID CHAR,
        CLINICAL_TRANSACTION_ID  CHAR,
        RESPONSE_TIME DECIMAL EXTERNAL,
        STATUS          CHAR  "UPPER(:status)",
        COLUMN1 FILLER CHAR ,
        COLUMN2 FILLER CHAR ,
        COLUMN3 FILLER CHAR ,
        COLUMN4 FILLER CHAR ,
        COLUMN5 FILLER CHAR ,
        COLUMN6 FILLER CHAR ,
        COLUMN7 FILLER CHAR ,
        COLUMN8 FILLER CHAR ,
        COLUMN9 FILLER CHAR ,
        COLUMN10        FILLER CHAR ,
        COLUMN11        FILLER CHAR ,
        COLUMN12        FILLER CHAR ,
        FILE_NAME CONSTANT  "SRC_102_16_15_00.csv",
        TRANSACTION_END_TIME "TO_TIMESTAMP(to_char(to_date(:FILLER1,'mm/dd/yy'),'mm/dd/yyyy') || ' ' || :FILLER2, 'MM/DD/YYYY HH24:MI:SSXFF')",
        TRANSACTION_START_TIME "TO_TIMESTAMP(to_char(to_date(:FILLER1,'mm/dd/yy'),'mm/dd/yyyy') || ' ' || :FILLER2, 'MM/DD/YYYY HH24:MI:SSXFF')  - NumToDsInterval(:RESP
ONSE_TIME,'SECOND')",
        LOCATION_ID  "substr('DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv',INSTR('DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv','_',1,1)
+1,INSTR('DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv','_',2,1) -1)",
        INSTALLATION_ID "substr('DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv',1,INSTR('DOMAIN11_LPAR1102_slainterval091713_ra71cmi102_16_15_00.csv','_',
1,1) -1)",
        TRANSACTION_ID "'AUTO-'||prt_trs_id_seq.nextval",
        ETL_DATE "SYSDATE"
)

parallel=true , multithreading=true , skip_index_maintenance=true

Path used: Direct 
Insert option in effect for this table: APPEND 
..............
..............
Total stream buffers loaded by SQL*Loader main thread: xxxx
Total stream buffers loaded by SQL*Loader load thread: xxxx