Home » SQL & PL/SQL » SQL & PL/SQL » Sql* Loader
Sql* Loader [message #220978] Fri, 23 February 2007 00:03 Go to next message
Messages: 67
Registered: October 2006

Hi all,

i m loading a csv file into oracle using sql loader but some records are coming in bad file. I want to know that how can i load those records again which is in bad files.

Thanks in advance.
Re: Sql* Loader [message #220980 is a reply to message #220978] Fri, 23 February 2007 00:08 Go to previous messageGo to next message
Messages: 7880
Registered: March 2000
Senior Member
Think. Think about how sql-loader works.
How did sql-loader know which file the original records were in?
Re: Sql* Loader [message #221029 is a reply to message #220978] Fri, 23 February 2007 05:16 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What kind of 'bad' records are they?
If those are creating by violation of constraints, there is an option. You can insert those records into an exception table inside database and deal with it later.
If the violation is on datatypes etc, there is no other option except what Frank has already said.
Previous Topic: Please Solve query
Next Topic: Passing Variables from a Procedure to an XML.
Goto Forum:

Current Time: Wed Jul 26 21:46:55 CDT 2017

Total time taken to generate the page: 0.21094 seconds