Re: One db too many

Thank you for your reply Edward,

[snip]

> 4) split your inserts [WHERE IN (x,y,z,...)] into chunks of 1000 ids

Do you mean splitting the SELECTS or is there actually a way to do inserts in chunks of 1000s? It is a one-column table, so theoretically it shouldn't be a problem, but it's not something i've seen anywhere.

>
> 5) instead of using array, save your IDs in a file and use Oracle
> SQLoader

I will try this as well.

Joakim

>
> -Edward
>
>
>
> --
> Posted via dBforums
> http://dbforums.com
>
Received on Tue Jan 15 2002 - 08:24:05 CET