DSXchange

Posted: **Mon Sep 18, 2006 6:33 pm**

Our company is planning to upgrade our database from oracle 8i to 10g. Due to some technical reason, one of our source database can't be upgraded (it's a oracle 7 database).

So now we have a situation where we are going to be reading from both version 10g and 7 database. We hope Datastage can use oracle 8 client with OCI8 and oracle 10g client with OCI9. Is this doable and how could I set this up?

Using Sun Unix. Datastage version 7.5.1A

Thanks

Posted: **Mon Sep 18, 2006 6:37 pm**

Not within the same job.

Otherwise, by dint of very careful installation and manipulation of Oracle environment variables, you may have both installed (in different locations), but you can only access one at any one time.

DSXchange

Using 2 different versions of oracle client on the same serv

Using 2 different versions of oracle client on the same serv