Could not determine version of Oracle for which to partition
Posted: Wed Jul 21, 2010 4:30 pm
We are getting a weird error in one of our parallel jobs.
This is our setup
AIX 5.3
Datastage 7.5
using oracle 10G or 11G client
connecting to
Oracle 11G database under 11G RAC.
The job has a native oracle stage which is using the TABLE read method to read from a table (say TAB1).
We are using the PARTITION TABLE option of the stage for TAB1.
We have 4 nodes defined.
When we run the job or even when we just view data we are getting this error -
Could not determine version of Oracle for which to partition. [orareadop.C:1606]
Please note that this job is running fine in the following two cases -
1. Datastage 7.5 using Oracle 10G client to connect to oracle 10G database.
2. Datastage 8.1 using Oracle 11G client to connect to Oracle 11G database.
Any advise as to where the problem may lie would be highly appreciated.
This is our setup
AIX 5.3
Datastage 7.5
using oracle 10G or 11G client
connecting to
Oracle 11G database under 11G RAC.
The job has a native oracle stage which is using the TABLE read method to read from a table (say TAB1).
We are using the PARTITION TABLE option of the stage for TAB1.
We have 4 nodes defined.
When we run the job or even when we just view data we are getting this error -
Could not determine version of Oracle for which to partition. [orareadop.C:1606]
Please note that this job is running fine in the following two cases -
1. Datastage 7.5 using Oracle 10G client to connect to oracle 10G database.
2. Datastage 8.1 using Oracle 11G client to connect to Oracle 11G database.
Any advise as to where the problem may lie would be highly appreciated.