On 2010-05-16, David Jarvis <thangalin(at)gmail(dot)com> wrote:
> --000e0cd516808361a40486acd38a
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> What is the fastest way to insert 237 million records into a table that has
> rules (for distributing the data across 84 child tables)?
segregate the data first and then copy it into the child tables.
else copy it into a temp table and insert it from there using
insert into CHILD_NAME select * from TEMPNAME where SEGREGATION CONDITION;
oryou may have success with the simple copy if you increase the number of file
handles and buffers sufficiently.