OPTIONS (SKIP=2,BINDSIZE=50000,ERRORS=0,ROWS=200,READSIZE=65536)
LOAD DATA
  CHARACTERSET WE8MSWIN1252
  INFILE '\\devora003.dev.tfl.local\PDW\PDW_Source\ISF_LUCC_Loadfile.csv' 
  CONCATENATE 1
INTO TABLE "STG_EWORK"."STG_ISF_LUCC"
  TRUNCATE
  REENABLE DISABLED_CONSTRAINTS
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' 
(
"STG_LOAD_DELTA_ID" EXPRESSION "FUNC_GET_DELTA_ID('MAP_STG_ISF_LUCC_TIN')",
"STG_LOAD_DATE" EXPRESSION "FUNC_GET_DELTA_DATE('MAP_STG_ISF_LUCC_TIN')",
"ISFNUMBER" POSITION(1) CHAR(15) "trim( :\"ISFNUMBER\" )" ,
"LUCC_CODE" CHAR(5) "trim( :\"LUCC_CODE\" )" 
)

MAP_STG_ISF_LUCC_TIN
Error
RPE-01013: SQL Loader reported error condition, number 1.

SQL*Loader: Release 10.2.0.3.0 - Production on Tue Jul 9 12:32:24 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Control File:   \\devora003.dev.tfl.local\PDW\PDW_Working\Control\isf_lucc.ctl
Character Set WE8MSWIN1252 specified for all input.

Data File:      \\devora003.dev.tfl.local\PDW\PDW_Source\ISF_LUCC_Loadfile.csv
  Bad File:     \\devora003.dev.tfl.local\PDW\PDW_Working\Control\ISF_LUCC_Loadfile.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 2
Errors allowed: 0
Bind array:     200 rows, maximum of 50000 bytes
Continuation:   Concatenate every 1 physical records
Path used:      Conventional

Table "STG_EWORK"."STG_ISF_LUCC", loaded from every logical record.
Insert option in effect for this table: TRUNCATE

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
"STG_LOAD_DELTA_ID"                                       EXPRESSION
    SQL string for column : "FUNC_GET_DELTA_ID('MAP_STG_ISF_LUCC_TIN')"
"STG_LOAD_DATE"                                           EXPRESSION
    SQL string for column : "FUNC_GET_DELTA_DATE('MAP_STG_ISF_LUCC_TIN')"
"ISFNUMBER"                             1    15   ,  O(") CHARACTER            
    SQL string for column : "trim( :"ISFNUMBER" )"
"LUCC_CODE"                          NEXT     5   ,  O(") CHARACTER            
    SQL string for column : "trim( :"LUCC_CODE" )"

SQL*Loader-643: error executing INSERT statement for table "STG_EWORK"."STG_ISF_LUCC"
ORA-01031: insufficient privileges

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

Table "STG_EWORK"."STG_ISF_LUCC":
  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.


Space allocated for bind array:                   5200 bytes(200 rows)
Read   buffer bytes:   65536

Total logical records skipped:          2
Total logical records read:             9
Total logical records rejected:         0
Total logical records discarded:        0

Run began on Tue Jul 09 12:32:24 2013
Run ended on Tue Jul 09 12:32:25 2013

Elapsed time was:     00:00:00.27
CPU time was:         00:00:00.07

SQL*Loader: Release 10.2.0.3.0 - Production on Tue Jul 9 12:32:24 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL*Loader-643: error executing INSERT statement for table "STG_EWORK"."STG_ISF_LUCC"
ORA-01031: insufficient privileges
SQL*Loader-2026: the load was aborted because SQL Loader cannot continue.