Hi All,
I have 60 mln records in source and want to split (based on rownum)and process them with multi instance job in the Sequnce job with loop (12 times).
For each instance, i would like to take 5 mln rows .
My database is Oracle10g.
Is it possible to split the records based on instance and rownum?.
if not,Please shed me somelight with better approach?
Thanks in advance.
Handling huge volume of data
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: