Sql*Loader-522 error
212178Feb 11 2010 — edited Feb 11 2010Hi,
I'm trying to load data into a table using SQL*Loader 10.1.0.2.0 but I can't due to the following error:
LoaderSQL*Loader-522: lfiopn failed for file (logs\ordencu.log).
The source of ctl file:
OPTIONS (ERRORS=10, DIRECT=true)
-- SILENT=(feedback), SKIP_INDEX_MAINTENANCE=no
UNRECOVERABLE LOAD DATA
TRUNCATE
INTO TABLE "ESML"."SML_ORDEN_CUMPLI" (
NUORDPRO POSITION(1) CHAR(13),
FEPROLAN DATE "yymmdd",
COTURSEC CHAR(01),
FEORDEN DATE "yymmdd",
FELANORD DATE "yymmdd",
TURNMONT CHAR(01),
FELANZCH DATE "yymmddhh24miss",
COTURCHA CHAR(01),
COLINMON CHAR(01),
FEPROORD DATE "yymmddhh24miss",
FEENCODC DATE "yymmddhh24miss",
COMODJAH CHAR(01),
CODTMA CHAR(03),
CODIMG CHAR(03),
COFABRIVW CHAR(02),
TIOCARR CHAR(04),
COTIPMOT CHAR(04),
COCOEXVW CHAR(02),
COCOTEVW CHAR(02),
COCOINVW CHAR(02),
COPAISVW CHAR(03),
COPAISPR CHAR(03)
)
I'm using Windows XP and all files are in the same directory as SQL Loader.
How can I fix it?
Thanks.