Re: [HELP]sqlldr question

by the way, under a scenerio is that.. everytime sqlldr will load data records no more than 1 million.
Can I issue a command like below seems will have a (all or none) insertion result:

sqlldr ***/**** errors=0 rows=1000000 *********

what do u think?

"Hantie" <blk330ci_at_hotmail.com> 撰寫於郵件新聞 :d86rfe$jf71_at_imsp212.netvigator.com...
> thanks Maxim..
> I've tested both Direct/conventional path and subsequently all records
were
> commit before error occurs.
> it seems to me that there is noway to make sqlldr rollback, am i correct?
>
> Jan
>
> "Maxim Demenko" <mdemenko_at_gmail.com> 撰寫於郵件新聞
> :d851sq$tfc$02$1_at_news.t-online.com...
> > "If you use direct path, commit happens at the end of the load," --
> > Maxim Demenko , "Re: [HELP]sqlldr question" (21:36)
> >
> > Sorry , it was not quite correct, during the direct load happens data
> > save , so if error occurs at the end of load , loaded records could not
> > be rolled back as well.
> >
> > Best regards
> >
> > Maxim
>
>
Received on Wed Jun 08 2005 - 09:29:56 CDT