Page 1 of 1
replacement for Oracle OCI
Posted: Wed Feb 28, 2007 10:12 am
by kirankota79
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...
Posted: Wed Feb 28, 2007 1:53 pm
by kumar_s
Use "Oracle Enterprise" stage.
Posted: Wed Feb 28, 2007 4:54 pm
by DSguru2B
Import your table using orchestrate 'orchbutil'. Thats more accurate.
Posted: Thu Mar 01, 2007 9:26 am
by kirankota79
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?
Posted: Thu Mar 01, 2007 4:00 pm
by ray.wurlod
Not only that, it's also necessary for correct function of the Oracle Enterprise stage. So you must demand these SELECT privileges.
Posted: Thu Mar 01, 2007 5:19 pm
by DSguru2B
I dont think orchbutil needs those extra priveliges. Its just the Enterprise stage. You can import with just access to that schema.
Posted: Fri Mar 02, 2007 2:49 am
by kumar_s
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.