 <p>A few issues you can run into if you just kill the sqlldr process:</p> <ul> <li>If the number of commit rows is small you may have data already-commited which will now have to be removed. This may not matter if you are truncating the tables before use but the cleanup is an operational issue that is dependent upon your system.</li> <li>If the number of commit rows and the size of your file is large then you may get issues with the rollback segments being too small or the rollback itself taking a long time to complete (shouldn't an issue if you are using direct path).</li> </ul> <p>You can kill using <code>kill -9</code> as mentioned, or you can kill the session from within the database:</p> <pre><code>alter system kill session 'sid,serial#'; </code></pre> <p>If you are using Windows then you can use the <a href="http://www.oracleutilities.com/OSUtil/orakill.html" rel="nofollow">orakill</a> utility.</p>