Upgradation from Oracle8 to 10g stage in Datastage

[Jagan617]

Is there any utility in datastage which automatically converts Oracle 8 stage to Oracle OCI stage, since we are upgrading the oracle from 8i to 10g. Need assistance on this? If so, how we can use that utility in datastage with example.

[sachin1]

hello friend their is one utility named OCI8TO9.B,but i have never used it, allows to migrate any oracle OCI8 stage in your job to oracle OCI stage.

[chulett]

It's on the Client CDROM in the Unsupported Utilities directory, from what I recall. However, I did make use of it once and it worked fine. Of course, there's a README that explains how to use it.