I'm reading records from Oracle table using OCI stage and write to a sequential file. The query performs UNION all operation on two tables which have history records and these tables have huge number of records. When I run the job, the job gets aborted with error
I'm performing min and max date functions on 2 date columns in all union statements in the query.Ora - Fetch out of sequence
What is the cause? Any help would be highly appreciated. If required I can post the query.