Page 1 of 1

Upgradation from Oracle8 to 10g stage in Datastage

Posted: Sat Sep 13, 2008 12:55 am
by 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.

Re: Upgradation from Oracle8 to 10g stage in Datastage

Posted: Sat Sep 13, 2008 4:03 am
by 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.

Posted: Sat Sep 13, 2008 7:27 am
by 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.