Data Loading in Oracle

gssr · Post by **gssr** » 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,

sajidkp · Post by **sajidkp** » 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

chulett · Post by **chulett** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.

sreekanth kutumbaka · Post by **sreekanth kutumbaka** » 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