Home » RDBMS Server » Server Utilities » Problem in sql loader (Oracle 10g, win xp)
Problem in sql loader [message #608897] Wed, 26 February 2014 07:03 Go to next message
Xandot
Messages: 102
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 67 times)
Re: Problem in sql loader [message #608899 is a reply to message #608897] Wed, 26 February 2014 07:22 Go to previous messageGo to next message
cookiemonster
Messages: 10929
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.
Re: Problem in sql loader [message #608900 is a reply to message #608899] Wed, 26 February 2014 07:33 Go to previous messageGo to next message
Xandot
Messages: 102
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
  • Attachment: M1AM13.CSV
    (Size: 0.71KB, Downloaded 24 times)
Re: Problem in sql loader [message #608902 is a reply to message #608900] Wed, 26 February 2014 07:48 Go to previous messageGo to next message
cookiemonster
Messages: 10929
Registered: September 2008
Location: Rainy Manchester
Senior Member
For external tables the relevant files have to be on the DB server.
Re: Problem in sql loader [message #608913 is a reply to message #608900] Wed, 26 February 2014 10:26 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 429
Registered: July 2003
Location: WPB, FL
Senior Member
Please Read The Fine Manual Oracle® Database SQL Language Reference, section ORGANIZATION EXTERNAL


[Updated on: Wed, 26 February 2014 10:45] by Moderator

Report message to a moderator

Re: Problem in sql loader [message #608953 is a reply to message #608897] Thu, 27 February 2014 07:38 Go to previous message
Xandot
Messages: 102
Registered: January 2014
Location: India
Senior Member
Thanks to all.....

Problem is resolved!!!!!




Previous Topic: Export backup status in oracle
Next Topic: Please explain SQL* Loader with simple example
Goto Forum:
  


Current Time: Mon Sep 01 19:19:19 CDT 2014

Total time taken to generate the page: 0.12941 seconds