
SQL*Loader: Release 12.1.0.2.0 - Production on Tue May 9 11:13:37 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Control File:   /archicom/data/ctlfiles/MOB_VOICE_jesh.ctl
Data File:      /archicom/data/toprocess/outputVOICE.unl
  Bad File:     badvoice.bad
  Discard File: tossvoice.dsc 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 10
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

Table MOBILE_VOICE, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
SEQ_NUM                             FIRST     *   ;  O(") CHARACTER            
TYPE                                 NEXT     *   ;  O(") CHARACTER            
WAY                                  NEXT     *   ;  O(") CHARACTER            
RECTYPE                              NEXT     *   ;  O(") CHARACTER            
SERVICE                              NEXT     *   ;  O(") CHARACTER            
POSTPRE                              NEXT     *   ;  O(") CHARACTER            
IMSI                                 NEXT     *   ;  O(") CHARACTER            
MSISDN                               NEXT     *   ;  O(") CHARACTER            
CALLINGNUM                           NEXT     *   ;  O(") CHARACTER            
DISP_CALLINGNUM                      NEXT     *   ;  O(") CHARACTER            
CALLEDNUM                            NEXT     *   ;  O(") CHARACTER            
DISP_CALLEDNUM                       NEXT     *   ;  O(") CHARACTER            
TYPENUM                              NEXT     *   ;  O(") CHARACTER            
STARTDATE                            NEXT     *   ;  O(") CHARACTER            
    SQL string for column : "TO_DATE(:StartDate, 'YYYYMMDDHH24MISS')"
DURATION                             NEXT     *   ;  O(") CHARACTER            
CDRTYPE                              NEXT     *   ;  O(") CHARACTER            
CAUSETERM                            NEXT     *   ;  O(") CHARACTER            
HOTBILL                              NEXT     *   ;  O(") CHARACTER            
ROAMNUM                              NEXT     *   ;  O(") CHARACTER            
CDRFILENAME                          NEXT     *   ;  O(") CHARACTER            
CMLSRVLVL                            NEXT     *   ;  O(") CHARACTER            
CMLSRVKEY                            NEXT     *   ;  O(") CHARACTER            
RECID                                NEXT     *   ;  O(") CHARACTER            
CALLREF                              NEXT     *   ;  O(") CHARACTER            
LAC                                  NEXT     *   ;  O(") CHARACTER            
CELLID                               NEXT     *   ;  O(") CHARACTER            
SUPPSERV                             NEXT     *   ;  O(") CHARACTER            
IMEI                                 NEXT     *   ;  O(") CHARACTER            
CMLLEGINFO                           NEXT     *   ;  O(") CHARACTER            
CMLINITCFIND                         NEXT     *   ;  O(") CHARACTER            
SYSTYPE                              NEXT     *   ;  O(") CHARACTER            
CALLTYPE                             NEXT     *   ;  O(") CHARACTER            
NE                                   NEXT     *   ;  O(") CHARACTER            
TRUNKIN                              NEXT     *   ;  O(") CHARACTER            
TRUNKOUT                             NEXT     *   ;  O(") CHARACTER            

value used for ROWS parameter changed from 64 to 28

Table MOBILE_VOICE:
  3655699 Rows successfully loaded.
  0 Rows not loaded due to data errors.
  0 Rows not loaded because all WHEN clauses were failed.
  0 Rows not loaded because all fields were null.


Space allocated for bind array:                 252840 bytes(28 rows)
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:       3655699
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Tue May 09 11:13:37 2017
Run ended on Tue May 09 11:29:36 2017

Elapsed time was:     00:15:58.96
CPU time was:         00:00:49.83
