OraFAQ Forum: Server Utilities » sqlldr and bad file

Home » RDBMS Server » Server Utilities » sqlldr and bad file

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

sqlldr and bad file [message #73324]

Wed, 24 March 2004 04:24

Brijesh
Messages: 8
Registered: January 2002

Junior Member

Hi,

We are running sqlldr to import the data from the flat text file. But sqlldr rejects nay one record 4 outof 7 times. When we lookinto the bad file for the same record it contains different record than recorded in log file. For example log file says 7282 and bad file contains record data from the 7283.

Please advise us a solution

Thanks

Report message to a moderator

Re: sqlldr and bad file [message #73325 is a reply to message #73324]

Wed, 24 March 2004 06:18

Brijesh
Messages: 8
Registered: January 2002

Junior Member

Hi ,
Currently sql loader is invoked from the Autosys job and if i run the same job manually it runs successfully.
When we run sqlldr, it runs successfully without any error and no record is rejected.
Please send your suggesstion.
thanks
Brijesh

Report message to a moderator

Re: sqlldr and bad file [message #73326 is a reply to message #73325]

Thu, 25 March 2004 03:05

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>When we run sqlldr, it runs successfully without any error
so sqlldr is working fine... something is wrong with ur autosys. I have no idea about autosys.
>>When we lookinto the bad file for the same record it contains different record
are there any trailing null values?
or usage of a database sequence?
other possibility is ur autosys may be padding up the record with line feeds.

Report message to a moderator

Previous Topic:	Export / Import fails with IMP-00058 and ORA-00604
Next Topic:	sqlloader help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 05:24:34 CDT 2024