DSXchange

Hi,

I am reading a Oracle source which is range partioned on a key column , i am doing a simple select from the Oracle source using a Oracle EE stage and paassing it to the target dataset. If I perform a normal read without specifying the partition table option, the job reads and loads fine without error. But when i specify the partition table option and then perform the read. I get the following Error ...

"main_program: (aptoci.C:388). Message: ORA-00942: table or view does not exist
(aptoci.C:524). Message: ORA-00942: table or view does not exist
(aptoci.C:436). Message: ORA-00942: table or view does not exist
(aptoci.C:493). Message: ORA-24374: define not done before fetch or execute and fetch".

One thing i can assure is the connection strings are all fine, as the source in the userdefined select and partition table are the same . The source reads 6 rows and loads it to the target as well and the job was finished successfully. But my only concern is why i get the error message

I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have defined in the stage. If you are saying that you are not allowing the stage to generate the sql, I would be wondering why that is.

chulett wrote:I'm guessing that between the ORA-24374 and your mention of "userdefined select" that the latter is the issue and you seem to have a mismatch between what's in the sql and the columns you have ...

I tried reading the whole table, using Read Method as Table with all the columns defined. But i still face the same issue.

My Partition Table is RDM.TBL_A, Read method = Table and Table = RDM.TBL_A.

Is your sql query working successfully on database prompt ?

Regards
Ulhas

My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

sridharvis wrote:My sql is working correctly in database prompt and in Datastage, except that in Datastage when i give the partiton table option i get the above error's
Regards
Sridhar V

Can you please help me in resolving the above partition table error.

If anyone could, they would have by now I would think. Time to turn to your official support provider if you haven't already.

Can you put the sql query here, which you are giving in Oracle Source Stage.

Regards
Ulhas

I have know more before I can suggest something?

Is it an Oracle partition or DataStage partition? Which type of partition method you are using?

Regards,

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

ray.wurlod wrote:Try qualifying the table name with its schema (owner) name. ...

No the problem still persists. I gave the schema name.owner name, but still facing the above error. But intrestingly the job did not abort and is still reading in parallel

"
main_program: This step has 1 dataset:
ds0: {op0[2p] (parallel Oracle_Enterprise_3)
eAny=>eCollectAny
op1[2p] (parallel Copy_6)}
It has 2 operators:
op0[2p] {(parallel Oracle_Enterprise_3)
on nodes (
node1[op0,p0]
node2[op0,p1]
)}
op1[2p] {(parallel Copy_6)
on nodes (
node1[op1,p0]
node2[op1,p1]
)}
It runs 4 processes on 2 nodes.
"