Re: Rollback after sql load

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:38:34 CDT