replacement for Oracle OCI

kirankota79 · Post by **kirankota79** » Wed Feb 28, 2007 10:12 am

Is there any replacement for Oracle OCI in parallel job? The table that is working with Oracle OCI in server job ...is not working with ODBC stage in parallel job. I have a problem with a column with a name "TIME_STAMP" for which the datastage is importing as LonVarBinary datatype instead of timestamp. When i changed it to datatype TIMESTAMP in server job, it is working.......but the samething i have done in parallel job...it is not working...saying that filed doesn't exist. I must do this job with parallel job...no other way.

help is appreciated...

kumar_s · Post by **kumar_s** » Wed Feb 28, 2007 1:53 pm

Use "Oracle Enterprise" stage.

DSguru2B · Post by **DSguru2B** » Wed Feb 28, 2007 4:54 pm

Import your table using orchestrate 'orchbutil'. Thats more accurate.

kirankota79 · Post by **kirankota79** » Thu Mar 01, 2007 9:26 am

i dont have select privileges on dba tables. They have given me the privilege only on the schema iam working. Is it necessary for orchbutil to have select privileges on dba or system tables?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2007 4:00 pm

Not only that, it's also necessary for correct function of the Oracle Enterprise stage. So you must demand these SELECT privileges.

DSguru2B · Post by **DSguru2B** » Thu Mar 01, 2007 5:19 pm

I dont think orchbutil needs those extra priveliges. Its just the Enterprise stage. You can import with just access to that schema.

kumar_s · Post by **kumar_s** » Fri Mar 02, 2007 2:49 am

Oracle's Date field has Timestamp portion in it. Datastage, has Date and Timestamp as different datatypes. You can pick the best close datatype for your requirement.