unable to load oracle table

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
philolaos
Premium Member
Premium Member
Posts: 11
Joined: Wed Sep 10, 2003 7:38 am
Location: Montreal, Canada
Contact:

unable to load oracle table

Post by philolaos »

hi,

I'm trying to load a binary file into an oracle table. I'm using a sequential file stage to read the file.

I'm getting this message

The call to sqlldr failed; the return code = 32,512;
please see the loader logfile: /appsdb/lvoradb09/opt/IBM/InformationServer/Server/Scratch/ora.6396.205060.0.log for details.

the log does is never created.

Any ideas!

Thanks
Stéphane Poirier
SHP Consult SA
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

What does /appsdb/lvoradb09/opt/IBM/InformationServer/Server/Scratch/ora.6396.205060.0.log tell you?
Last edited by ray.wurlod on Tue Feb 03, 2009 7:14 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
philolaos
Premium Member
Premium Member
Posts: 11
Joined: Wed Sep 10, 2003 7:38 am
Location: Montreal, Canada
Contact:

Post by philolaos »

Someone ran a test with my dsxchange account! Oracle library was not properly installed at that time. Just ignore this.
Stéphane Poirier
SHP Consult SA
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Oooh, no, I don't think we can ignore it. Tell us what you did to castigate this "someone"!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply