Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback after sql load

Re: Rollback after sql load

From: nn <nn_at_n.com>
Date: Tue, 23 Jul 2002 16:19:41 +0200
Message-ID: <ahjot8$6mh$1@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?

"Excuse me for my frensh english :-)"

"Richard Foote" <richard.foote_at_bigpond.com> a écrit dans le message news: _tc%8.42246$Hj3.125249_at_newsfeeds.bigpond.com...
> Hi NN,
>
> I'm not too sure why you are asking if you can rollback after sql*loader
has
> strut it's stuff ? Why would you want to rollback ?
>
> If you're using a Conventional Load, the BINDSIZE and ROWS parameters
govern
> how much data is committed at a time.
>
> If you're using a Direct Load, then ROWS controls the size of the data
save
> and frequency of commits. If you don't specify rows, then the commit is
> performed at the end (can't get any higher than that).
>
> But at the end, a commit is performed no matter what (therefore a rollback
> will do about as much as slug in a coma).
>
> May I suggest a quick squiz at the Utilities manual, read up on all the
> various options and pick the ones most applicable to your requirements.
>
> Good Luck
>
> Richard
>
> "nn" <nn_at_n.com> wrote in message
> news:ahj98i$rmo$1_at_s1.read.news.oleane.net...
> I mean sql*loader of course.
> but if i do : sqlldr login/pssword control=... data=.... rows=Number
> does oracle commit each number of rows reached? in this case, i make
Number
> high possible!
> is this true? (for the moment , i can't test in our database)
>
> Tx
>
>
>
>
>
> "Telemachus" <telemachus_at_ulysseswillreturn.net> a écrit dans le message
> news: vu9%8.4089$zX3.3488_at_news.indigo.ie...
> > If you mean SQL*Loader
> >
> > Did it finish OK ?
> >
> > Then you can't ... it's committed .
> >
> > Use the backup tape you cut before you loaded it.
> >
> > otherwise in sql*plus
> >
> >
> > Connected to:
> > Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
> > With the Partitioning, OLAP and Oracle Data Mining options
> > JServer Release 9.2.0.1.0 - Production
> >
> > SQL> create table boyoboy(col1 number);
> >
> > Table created.
> >
> > SQL> insert into boyoboy values (12);
> >
> > 1 row created.
> >
> > SQL> select count (*) from boyoboy;
> >
> > COUNT(*)
> > ----------
> > 1
> >
> > SQL> rollback
> > 2 ;
> >
> > Rollback complete.
> >
> > SQL> select count (*) from boyoboy;
> >
> > COUNT(*)
> > ----------
> > 0
> >
> > SQL>
> >
> >
> > "nn" <nn_at_n.com> wrote in message
> > news:ahj64p$p8r$1_at_s1.read.news.oleane.net...
> > > Hi
> > > How can i perform a ROLLBACK after a sql load operation?
> > > Tx
> > >
> > >
> >
> >
>
>
Received on Tue Jul 23 2002 - 09:19:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US