OPTIONS (DIRECT=TRUE, ERRORS=500000)
UNRECOVERABLE
load data
infile '{FILENAME}'
append
into table TBL_NAME
fields terminated by '|'
TRAILING NULLCOLS
(
)

SQL*Loader: Release 12.1.0.2.0 - Production on Wed Aug 31 04:00:00 2016

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

Control File:   /tmp/ctl.Gu07nFvAOk
Data File:      /var/log/2016-08-31-03-11.log
  Bad File:     /var/log/load_20160831040000.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 500000
Continuation:    none specified
Path used:      Direct

Load is UNRECOVERABLE; invalidation redo is produced.

Table TABLE_LOG, 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
------------------------------ ---------- ----- ---- ---- ---------------------
COLUMN_1                             FIRST     *   |       CHARACTER            
COLUMN_2                             NEXT     *   |       CHARACTER            
COLUMN_3                          NEXT     *   |       CHARACTER            
COLUMN_4                                NEXT     *   |       CHARACTER            
COLUMN_5                             NEXT     *   |       CHARACTER            

SQL*Loader-925: Error while uldlgs: OCIStmtExecute (ptc_hp)
ORA-00060: deadlock detected while waiting for resource

SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.

Table TABLE_LOG:
  0 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.

  Date conversion cache disabled due to overflow (default size: 1000)

  Sub-Partition SSPY_31_03_01: 21764 Rows loaded.
  Sub-Partition SSPY_31_03_02: 22608 Rows loaded.
  Sub-Partition SSPY_31_03_03: 22509 Rows loaded.
  Sub-Partition SSPY_31_03_04: 22401 Rows loaded.
  Sub-Partition SSPY_31_03_05: 21832 Rows loaded.
  Sub-Partition SSPY_31_03_06: 22451 Rows loaded.
  Sub-Partition SSPY_31_03_07: 21987 Rows loaded.
  Sub-Partition SSPY_31_03_08: 21984 Rows loaded.
  Sub-Partition SSPY_31_03_09: 21981 Rows loaded.
  Sub-Partition SSPY_31_03_10: 21868 Rows loaded.
  Sub-Partition SSPY_31_03_11: 21892 Rows loaded.
  Sub-Partition SSPY_31_03_12: 22158 Rows loaded.
  Sub-Partition SSPY_31_03_13: 22585 Rows loaded.
  Sub-Partition SSPY_31_03_14: 22168 Rows loaded.
  Sub-Partition SSPY_31_03_15: 21789 Rows loaded.
  Sub-Partition SSPY_31_03_16: 22663 Rows loaded.
  Sub-Partition SSPY_31_04_01: 12 Rows loaded.
  Sub-Partition SSPY_31_04_02: 19 Rows loaded.
  Sub-Partition SSPY_31_04_03: 14 Rows loaded.
  Sub-Partition SSPY_31_04_04: 19 Rows loaded.
  Sub-Partition SSPY_31_04_05: 20 Rows loaded.
  Sub-Partition SSPY_31_04_06: 14 Rows loaded.
  Sub-Partition SSPY_31_04_07: 15 Rows loaded.
  Sub-Partition SSPY_31_04_08: 18 Rows loaded.
  Sub-Partition SSPY_31_04_09: 16 Rows loaded.
  Sub-Partition SSPY_31_04_10: 16 Rows loaded.
  Sub-Partition SSPY_31_04_11: 21 Rows loaded.
  Sub-Partition SSPY_31_04_12: 17 Rows loaded.
  Sub-Partition SSPY_31_04_13: 17 Rows loaded.
  Sub-Partition SSPY_31_04_14: 15 Rows loaded.
  Sub-Partition SSPY_31_04_15: 12 Rows loaded.
  Sub-Partition SSPY_31_04_16: 11 Rows loaded.

Bind array size not used in direct path.
Column array  rows :   10000
Stream buffer bytes:16777216
Read   buffer bytes: 1048576

Total logical records skipped:          0
Total logical records read:        354896
Total logical records rejected:         0
Total logical records discarded:        0
Total stream buffers loaded by SQL*Loader main thread:       86
Total stream buffers loaded by SQL*Loader load thread:        0

Run began on Wed Aug 31 04:00:00 2016
Run ended on Wed Aug 31 04:03:55 2016

Elapsed time was:     00:03:55.37
CPU time was:         00:00:02.15