Loading 10000 ids at a time from source to target
Posted on 2012-03-29
I have a table xyz_src with 20 million records as follows:
42342 sjkfhs ----this is 10000th id in the table
43456 wefrwr --- this is 10001th id in the table
as you can see, id is not sequential
i need to select 10000 ids at a time in the ascenting order and load into target say xyz_tgt
next time i need to second 10000 ids and load into target starting from 10001th id..
how to do this in a loop..the src and tgt table structures are same..