write() failed: Broken pipe

[kool78]

Hi Gurus

I troed to do a search on broken pipe issues and found this could be a space problem...

as i wasn't sure of it...

can you please let me know what would be the cause of this errors :

ORA,0: write() failed: Broken pipe
ORA,0: Export failed.
ORA,0: write() failed: Bad file number


My job inserts records into Oracle table using Load Append menthod from dataset.

any mind of help is appreciated.

Thanks

[johnthomas]

Look into Sql loader log in Scratch directory , which should give some clue to resolve it

[Apotluri]

Please verify the log under 'Scratch' folder in unix, there may be some data issue.
some times the fields may come with invalid data or invalid data type,so while inserting it may create a problem

If not sit with your DBA and ask them to give stats while loading..

--Arvind