Home » RDBMS Server » Server Utilities » commit to the end of the load
icon5.gif  commit to the end of the load [message #155635] Tue, 17 January 2006 14:12 Go to next message
arismendez
Messages: 3
Registered: December 2005
Junior Member
hi

Im using sql*loader to load my data. My problem is this, if one row of my file is rejected due to some reason,then the entire data should not load or delete the rows that they load. What can i do to do this??

tnx for the help..

Report message to a moderator

Re: commit to the end of the load [message #155637 is a reply to message #155635] Tue, 17 January 2006 14:19 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
use errors=0

Report message to a moderator

Previous Topic: Re: Strange error ORA-12514
Next Topic: SCRIPT FOR REFRESH
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 02 04:38:26 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.