Error while Loading a table using ORACLE
Moderators: chulett, rschirm, roy
Error while Loading a table using ORACLE
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 .
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 .
gikjpjj
-
- Premium Member
- Posts: 236
- Joined: Sun Apr 01, 2007 7:41 am
- Location: Michigan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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 ??
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 ??
gikjpjj
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
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
199542 wrote: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 ??
gikjpjj