Error while Loading a table using ORACLE

[199542]

Hi all ,
Thank you all for resolving number of issues till now .

Right Now , I got another problem while loading a oracle table using

datastage.

write method :load

My job structure is like this

seq --->> transformer --->> oracle table

I am getting below error
Oracle_Enterprise_4,0: The system(sqlldr dbuser/db12345@orcl CONTROL=ora.8736.483000.0.ctl LOG=ora.8736.483000.0.log BAD=ora.8736.483000.0.log.bad SILENT=header PARFILE=ora.8736.483000.0.par) failed; see the log file for the Oracle specific message.
Here username : dbuser password:db12345@orcl service name :orcl

Can anybody please help me regarding the above error ??
Thanks in advance .

[chulett]

Did you "see the log file for the Oracle specific message"?

[just4u_sharath]

CHECK THIS LOG ora.8736.483000.0.log IT WILL SHOW U EXACTLY WHAT THE ERROR IS,AND IT MAY BE NULLS COMING FROM SOURCE DATA WHICH WAS NOT HANDLED IN TRANSFORMATION,OR MAY BE ORACLE LOADER ERROR,CHECK THE LOG AND COPY AND PAST IT IN WORD DOC U CAN HAVE CLEAR PICTURE.

[chulett]

No shouting please, inside voices only.

[shamshad]

EnnnhHHH , It took me a while to read those CAPS sentences

[ray.wurlod]

The second person personal pronoun in English is spelled "you", not "u".

[199542]

Hi ,
Thank you all for your replies . I have seen the log file and i am getting the following error .

Record 1: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 2: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 3: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 4: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 5: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 6: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 7: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 8: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 9: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 10: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 11: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

I am not able to comprehend what this error is all about ?
Can anybody help me regarding this one ??

[199542]

Hi Everybody ,
I resolved the error .Previously , I gave length of the coloumn more than source filed in the table definition .I changed it and it worked well.Once again I am thankful to all for helping me out in this errror

Hi ,
Thank you all for your replies . I have seen the log file and i am getting the following error .

Record 1: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 2: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 3: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 4: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 5: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 6: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 7: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 8: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 9: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 10: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

Record 11: Rejected - Error on table table_name, column col_name.
ORA-01438: value larger than specified precision allows for this column

I am not able to comprehend what this error is all about ?
Can anybody help me regarding this one ??

[chulett]

Excellent. Now time to mark the thread as Resolved.