Page 1 of 1

Could not determine version of Oracle for which to partition

Posted: Wed Jul 21, 2010 4:30 pm
by hsahay
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.

Posted: Thu Jul 22, 2010 5:45 am
by Druid_Elf
I believe there is no official support from datastage 7.5 for oracle 11.
Oracle 11 is supported from datastage 8.X

This might the source of your problem.
Otherwise drop the partition option and see if you can connect.

Someone who had the problem with version 10:

http://datawarehouse.ittoolbox.com/grou ... le-3081711

Best to check with support :)