Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback after sql load
"nn" <nn_at_n.com> wrote in message
news:ahjot8$6mh$1_at_s1.read.news.oleane.net...
> Thank you Richard
> I've a critical table, and I would that sql loader's loading can be made
> correctly. if for example, the sql loader exit with error because the max
> extent have been reached, the stuff loaded before error, have it been
> committed?
It depends. Generally sql*loader commits every 'n' records. Thus it is likely that some but not all of the data will have been committed.
What I would do is to load into a staging table and only if this load is successful insert/update the production table from the staging table.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ******************************************Received on Tue Jul 23 2002 - 09:29:24 CDT