Re: Pls help me with this migration scenario..

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 Received on Sat Mar 26 2005 - 09:45:30 CST