Re: Pls help me with this migration scenario..

xtanto_at_hotmail.com wrote in message news:<1111851930.761983.323640_at_z14g2000cwz.googlegroups.com>...
> 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

>>IOW, Is there aniway to set that every, e.g: 100 rows inserted, it will do COMMIT ??
Yes: PL/SQL.

Cheers. Received on Sat Mar 26 2005 - 14:47:57 CST