Home » RDBMS Server » Server Utilities » Some records errored out in an oracle load
Some records errored out in an oracle load [message #69760] Fri, 01 March 2002 12:05 Go to next message
Sue
Messages: 49
Registered: May 2000
Member
Help!
I appended about 20000 records into an Oracle table with the help of sqlloader. About 500 records did not get loaded due to some errors. Let us say, that I fix these 500 records and then do I have to have a seperate text file for these 500 records or can I take the original file fix it and load the file asking Oracle to just load the 500 it missed loading. What command I should use. Will a skip work?
Sue

Report message to a moderator

Re: Some records errored out in an oracle load [message #69762 is a reply to message #69760] Fri, 01 March 2002 17:47 Go to previous message
Jim Willis
Messages: 11
Registered: October 2001
Junior Member
the easiest way is to just fix the records in the discard or rejected file/s and then load them.

Report message to a moderator

Previous Topic: Automating loading data into Oracle
Next Topic: Re: FREE OCP PAPERS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 08:29:52 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.