Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback after sql load
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 - 04:52:38 CDT