OraFAQ Forum: Server Utilities » Problem in sql loader

Home » RDBMS Server » Server Utilities » Problem in sql loader (Oracle 10g, win xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem in sql loader [message #608897]

Wed, 26 February 2014 07:03

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Hi friends,
i want to load the data through sql loader then the following error is coming ...

Why this type of error is raise ...Please help me out....

Thanks

Attachment: untitled.JPG
(Size: 107.71KB, Downloaded 1910 times)

Report message to a moderator

Re: Problem in sql loader [message #608899 is a reply to message #608897]

Wed, 26 February 2014 07:22

cookiemonster
Messages: 13975
Registered: September 2008
Location: Rainy Manchester

Senior Member

That's an external table, not sqlloader. The two are related but they are not the same.
The message is self explanatory - oracle can't find a file it's looking for.
Does it exist on the DB server in a directory that oracle has access to?
For further help I suggest you post the external table definition.

Report message to a moderator

Re: Problem in sql loader [message #608900 is a reply to message #608899]

Wed, 26 February 2014 07:33

Xandot
Messages: 235
Registered: January 2014
Location: India

Senior Member

Is it possible to run external table on client m/c..........
Here the defination of external table & also attached CSV file ..........
------------------------------------------------
CREATE TABLE M123
(ACODE VARCHAR2(10) ,
ANAME VARCHAR2(100))
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY NIL
ACCESS PARAMETERS (
RECORDS DELIMITED BY NEWLINE
FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(ACODE CHAR(10) ,
ANAME CHAR(100) )
)
LOCATION ('M1AM132.CSV')
)REJECT LIMIT UNLIMITED
-------------------------------------------------------

Thank