Re: Pls help me with this migration scenario..

On 26 Mar 2005 07:45:30 -0800, xtanto_at_hotmail.com wrote:

>Hi,
>
>> First off, do you believe the sqlldr somehow bypasses constraints?
>What I mean is :
>If using SQL Loader, If I Insert 1 million rows and one row fails, the
>rest of the rows will be inserted and that one failed row will be
>reported as Bad.
>But if using INSERT INTO ... SELECT ...FROM ... the whole batch will be
>rolled back if just one row fails. How can I get the above Sql Loader
>feature if using INSERT INTO... ??
>IOW, Is there aniway to set that every, e.g: 100 rows inserted, it will
>do COMMIT ??
>
>Thank you for your help,
>Krist

Obviously you are weary of reading manuals. I already pointed you to the EXCEPTIONS INTO of the constraint clause.

Sql*loader will commit every array.
The size of the array can be set.

Do you really need to have everything spelled out for you?

--
Sybrand Bakker, Senior Oracle DBA