Home » RDBMS Server » Server Utilities » Control File
icon6.gif  Control File [message #246583] Thu, 21 June 2007 07:06 Go to next message
kcjohn.lin
Messages: 8
Registered: June 2007
Location: london
Junior Member
Hello

I have a question, it might be simple but I can not find an answer to.

what setting would you use to reject the file if 1 record is not accepted?
and
what setting would you use to load the file reguardless of the number of errors?

regards

John
Re: Control File [message #246588 is a reply to message #246583] Thu, 21 June 2007 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Setting of what? ./fa/1587/0/

Regards
Michel
icon6.gif  Re: Control File [message #246603 is a reply to message #246588] Thu, 21 June 2007 07:55 Go to previous messageGo to next message
kcjohn.lin
Messages: 8
Registered: June 2007
Location: london
Junior Member
hello

errr!! don't know.
that was the actual question that I've been asked.

maybe something that i can use to stop the loading process once a
value is not accepted whilst loading into a table!!

thanks
john Razz
Re: Control File [message #246605 is a reply to message #246583] Thu, 21 June 2007 07:57 Go to previous messageGo to next message
pablolee
Messages: 2836
Registered: May 2007
Location: Scotland
Senior Member
This sounds like a SQL*Loader question.
Look at the REJECT LIMIT value.
Re: Control File [message #246607 is a reply to message #246583] Thu, 21 June 2007 07:59 Go to previous messageGo to next message
kcjohn.lin
Messages: 8
Registered: June 2007
Location: london
Junior Member
hello

sorry i don't mention

its about sql*loader

thanks
Re: Control File [message #246611 is a reply to message #246607] Thu, 21 June 2007 08:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So pablolee gave you the answer.

Regards
Michel
Re: Control File [message #246617 is a reply to message #246611] Thu, 21 June 2007 08:42 Go to previous message
kcjohn.lin
Messages: 8
Registered: June 2007
Location: london
Junior Member
thanks

michel
Previous Topic: Commit in sqlldr
Next Topic: SQL*Load - prevent carriage return char in last column?
Goto Forum:
  


Current Time: Fri Dec 09 15:57:38 CST 2016

Total time taken to generate the page: 0.13606 seconds