Oracle Load Problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
Oracle Load Problem
I got a problem when I try to load data file to oracle by datastage.
If the column length is more than 300, I always get an oracle errors say column lengh exceed maxium length.
And if I change the loading method to upsert, it is OK, I can even insert 4000 length column into oracle.
But when I changed it back to Load method, it alwasy doesn't work.
Anyone can help ? thanks
If the column length is more than 300, I always get an oracle errors say column lengh exceed maxium length.
And if I change the loading method to upsert, it is OK, I can even insert 4000 length column into oracle.
But when I changed it back to Load method, it alwasy doesn't work.
Anyone can help ? thanks
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
-
- Participant
- Posts: 161
- Joined: Wed Aug 02, 2006 4:30 am
thanks for your output.ArndW wrote:Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the explicit column definitions into this file. You should take it up with your support provider. ...
I still couldn't make it work. I use upsert method at this moment. And I raised my questions to IBM guys. They did the test. And come back to me say that it works on their Oracle system.
I don't know whether I need to do some special configuration in Oracle. However, if I test a sqlldr control file (with column length) in my oracle, it works
-
- Participant
- Posts: 73
- Joined: Tue May 10, 2005 6:21 pm
- Location: Sydney
Did you set the environment variable APT_ORACLE_LOAD_DELIMITED in your job? Also are there any double quotes in the input data?
What error did you get in the sqlldr log? Can you post the sqlldr log file?
What error did you get in the sqlldr log? Can you post the sqlldr log file?
xinhuang66 wrote:thanks for your output.ArndW wrote:Sounds like there might be a bug when DataStage creates the load file and doesn't inherit the explicit column definitions into this file. You should take it up with your support provider. ...
I still couldn't make it work. I use upsert method at this moment. And I raised my questions to IBM guys. They did the test. And come back to me say that it works on their Oracle system.
I don't know whether I need to do some special configuration in Oracle. However, if I test a sqlldr control file (with column length) in my oracle, it works
Edward Yuan