DSXchange

Posted: **Thu Oct 15, 2009 2:44 am**

While loaading a dataset with 26 records to the TARGET Database Oracle, i could able to load only seven records with an error message:

Oracle_Enterprise_135,3: The system(sqlldr scretl/scretl@tpcs CONTROL=ora.2928834.310994.3.ctl LOG=ora.2928834.310994.3.log BAD=ora.2928834.310994.3.log.bad SILENT=header PARFILE=ora.2928834.310994.3.par) failed; see the log file for the Oracle specific message

Can anyone suggest me an solution for this
Thanks in advance,

Posted: **Thu Oct 15, 2009 2:55 am**

Can you give some more details like

1) which stage you are using for loading
2) Sqlldr log file content
3) Sqlldr parameters

May be sombody can help you

Posted: **Thu Oct 15, 2009 5:31 am**

gssr wrote:see the log file for the Oracle specific message

The error will be in the log, hence the message.

Posted: **Thu Oct 15, 2009 3:26 pm**

You may need to look on scratchdisk to find the log, if you have not specified a location for the sqlldr log file to be written.

Posted: **Tue Oct 20, 2009 4:34 am**

you may need to look into the free space available @ ORACLE end as well. because, if there is no free space available in DB side, then we might end up getting this error

Thanks & Regards,
Dinesh

DSXchange

Data Loading in Oracle

Data Loading in Oracle

Re: Data Loading in Oracle

reply