Handling huge volume of data

[naren6876]

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.

[chulett]

First let us know what "process" means, what do you actually have to do with this data? And what is your target?

[ray.wurlod]

Just dream up appropriate WHERE clauses (probably with job parameters for the constant(s)) for extraction SQL.