Problem with Oracle Load

Raftsman · Post by **Raftsman** » Thu Aug 19, 2010 9:46 am

We are encountering a weird issue with the Oracle Load option in the Oracle EE stage. If we use this option with Sequential Files or Datasets as input, the LOAD option works. It we use an Oracle EE stage as input and an Oracle EE stage as output, no data get loaded. The log shows the number of records being exported but after reviewing the XXXX.ora file, no records are written and no error produced.

I opened a PMR with IBM and they produced a patch but it still doesn't work. Has anyone else encountered this issue and if so, did you find a solution.

If we use the upsert, everything is fine. In some cases, we would like to use the LOAD.

Thanks in advance.

ArndW · Post by **ArndW** » Thu Aug 19, 2010 10:10 am

Do you know what the patch addressed - that would be where I'd start looking.

priyadarshikunal · Post by **priyadarshikunal** » Thu Aug 19, 2010 11:12 am

Have you tried DIRECT=FALSE option?

Raftsman · Post by **Raftsman** » Thu Aug 19, 2010 11:17 am

Yes, tried a number of different options. Even tried it on version 8.0.1. We have both versions. Still trying to determine why. What's very strange is, I can't find the ctl file or the fifo.out file.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Aug 20, 2010 2:19 am

Did you try including a copy stage with force option or probably a transformer ?

siauchun84 · Post by **siauchun84** » Sun Aug 22, 2010 7:36 pm

Is there any Reference available in your target table?
Have you tried to load those records to a temp table?