Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sql*Loader-522 error

212178Feb 11 2010 — edited Feb 11 2010
Hi,

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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2010
Added on Feb 11 2010
1 comment
2,177 views