Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Pls help me with this migration scenario..

Re: Pls help me with this migration scenario..

From: <xtanto_at_hotmail.com>
Date: 26 Mar 2005 07:45:30 -0800
Message-ID: <1111851930.761983.323640@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 Received on Sat Mar 26 2005 - 09:45:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US