OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Control File

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Control File [message #246583]

Thu, 21 June 2007 07:06

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

Report message to a moderator

Re: Control File [message #246588 is a reply to message #246583]

Thu, 21 June 2007 07:14

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Setting of what? /forum/fa/1587/0/

Regards
Michel

Report message to a moderator

Re: Control File [message #246603 is a reply to message #246588]

Thu, 21 June 2007 07:55

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