SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

fetching n number of rows from a milllion records database

SC_CSApr 10 2009 — edited Apr 10 2009

Hi

we have a database having 30 million records and i want to divide that table into multi tables, like I want to fetch first 2 million records and want to put in a new table, then next 2 million records to new table; how can i do that using a single query or procedure with good performance.

Thanks
Shaveta

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2009

Added on Apr 10 2009

13 comments

657 views