ORA-00942: table or view does not exist

austin_316 · Post by **austin_316** » Wed Jun 01, 2011 4:15 am

hi colin,
got any solution for this issue. We too are facing similar issue.
its giving the error

main_program: (aptoci.C:355). Message: ORA-00942: table or view does not exist
(aptoci.C:491). Message: ORA-00942: table or view does not exist
(aptoci.C:403). Message: ORA-00942: table or view does not exist
(aptoci.C:460). Message: ORA-24374: define not done before fetch or execute and fetch

we have oracle enterprise stage which is trying to read data from a table partitioned in the database and store the records in a dataset.

we tried giving the Read Method as Table/User Defined SQl/Auto-Generated SQl. but the same error gets popped up in all of the cases.

Regards,
ravi.

chulett · Post by **chulett** » Wed Jun 01, 2011 6:33 am

Please don't hijack old posts, when you have a problem no matter how "similar" it may be to something you've found, start your own post. Then you have control over its fate.

Also, please edit your post and add the required information we're missing - O/S, version, etc.

austin_316 · Post by **austin_316** » Thu Jun 02, 2011 12:37 am

Apologies for posting over the old one.
i have updated the details like datastage version,o/s and job type.
kindly help me in solving the issue.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 02, 2011 12:45 am

Try qualifying the table name with its schema (owner) name.

SURA · Post by **SURA** » Thu Jun 02, 2011 12:50 am

Check the privilege for the user connecting Oracle through Datastage.

DS User

austin_316 · Post by **austin_316** » Thu Jun 02, 2011 9:29 pm

hi,
Although the job is giving this error, data from the table is fetched and iam able to store the data in a dataset. we have given the value for partitiontable and table in the properties as #$SRC_SCHEMA#.SAMPL_PART_TBL.
And also the status of the job in the websphere datastage director is shown as Finished

ray.wurlod · Post by **ray.wurlod** » Fri Jun 03, 2011 12:26 am

In the "Job starting" event in the log, verify that the environment variable job parameter has a valid value.

austin_316 · Post by **austin_316** » Fri Jun 03, 2011 4:00 am

hi ray,
thanks for the reply.
i have checked the value for the variable in the log. it is having the proper value. one more point i forgot to mention is when i remove the property "Partition Table" from the oracle enterprise we are not getting the error and if we keep it job is running successful(Status updated as Finished) and records are being fetched, but iam seeing this fatal error in the logs.

DSXchange