pick up number of records from a table at one time

[mpramods]

I have a large oracle table with 40 Million records.
I need to pull out 100,000 records each time and put it into a temporary table and process it, due to space issue.
After these records are processed, I need to pick up the next 100,000 records and do the same till the end.
I need to do the above using a unix shell script.
Can anybody tell me how to write this script.

Thanks a lot,
Pramod.

 

[dickiebird]

Take a look at faq822-2218
It'll show you all you need to know. To connect to Oracle, create tables, perform loads etc. etc.....

Dickie Bird (-)))