Re: Bulk Insert

On 2010-05-16, David Jarvis <thangalin@gmail.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.