Partition Read in ORACLE connector stage

[siva7143]

Hi All,

Two tables created in ORACLE without any partition method. Eg: Table1 and Table2.

While trying to run the job using the Table1 with property in ORACLE connector stage with

Enable Partitioned Reads : Yes
Partitioned Reads Method : Rowid hash



Job aborts : "Error code: 923, Error message: ORA-00923: FROM keyword not found where expected"

When we run the job for Table2 with same properties in ORACLE stage
Enable Partitioned Reads : Yes
Partitioned Reads Method : Rowid hash, it runs fine.

Kindly let me know how can we resolve this......

[BI-RMA]

Please provide the actual SQL-Statement (with parameters) as used in the Stage.

[jcook]

Can you explain why you would want to do partitioned reads from a non-partitioned table?

[nagarjuna]

Can you explain why you would want to do partitioned reads from a non-partitioned table?

I guess to read the data in parallel & make it fast