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.
Problem with Oracle Load
Moderators: chulett, rschirm, roy
Problem with Oracle Load
Jim Stewart
Do you know what the patch addressed - that would be where I'd start looking.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 63
- Joined: Mon Oct 20, 2008 12:01 am
- Location: Malaysia