ORAOCI8 versus Oracle 8 Bulk Load

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
crouse
Charter Member
Charter Member
Posts: 204
Joined: Sun Oct 05, 2003 12:59 pm
Contact:

Post by crouse »

Performance will almost always be better. But, if the Oracle server instance and the DataStage server don't exist on the same box, you won't be able to use the ORAOCIBL, as that stage relies on an Oracle DLL present in the Oracle instance installation (not the client installation).

There MAY be a way around it by copying the DLL(s) from the Oracle server intallation, but all bets are off at that time.
Craig Rouse
Griffin Resouces, Inc
www.griffinresources.com
Post Reply