Oracle Enterprise read method
Posted: Tue Apr 14, 2009 1:08 pm
Hi,
Iam using oracle Enterprise stage to read data from a table
SELECT * FROM EMP WHERE EXISTS
(SELECT DEPT FROM DEPT A
WHERE A.DEPT_NO = EMP.DEPT_NO)
ORDER BY EMP.ENAME
When I am using above query to run my job to extract from oracle enterprise stage it is extracting only 5000000 (half million) instead of 1 million records . When I ran the same query in SQL* PLUS it is giving me 1 million.
I tried the option of ARRAYSIZE in DB OPTION and changed to 4000 but no help. I ran the same job for less volume of data like 400000 the job is working fine ( with out changing any seetings like array size) but when I ran huge volume of data it is not extracting all records from the stage.
Is there any setting that we need to handle like ENV variable.
Thanks,
Somaraju.
Iam using oracle Enterprise stage to read data from a table
SELECT * FROM EMP WHERE EXISTS
(SELECT DEPT FROM DEPT A
WHERE A.DEPT_NO = EMP.DEPT_NO)
ORDER BY EMP.ENAME
When I am using above query to run my job to extract from oracle enterprise stage it is extracting only 5000000 (half million) instead of 1 million records . When I ran the same query in SQL* PLUS it is giving me 1 million.
I tried the option of ARRAYSIZE in DB OPTION and changed to 4000 but no help. I ran the same job for less volume of data like 400000 the job is working fine ( with out changing any seetings like array size) but when I ran huge volume of data it is not extracting all records from the stage.
Is there any setting that we need to handle like ENV variable.
Thanks,
Somaraju.