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
Using 2 different versions of oracle client on the same serv
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.