A question on rollback

Hello Everyone,

        I am explaining my problem with an example. Please see the following.

SQL> select * from temp1;

A B

-------------------- ----------
SMITH			    800
ALLEN			   1600
WARD			   1250
JONES			   2975
MARTIN			   1250

SQL> delete from temp1;

5 rows deleted.

SQL> rollback;

Rollback complete.

SQL> select * from temp1;

no rows selected
^^^^^^^^^^^^^^^^

WHY ??. temp1 table is supposed to get back to its original 5 rows. But, it is not showing any rows after rollback.

If I have WHERE (some_conditon) in delete statement, rollback is working as expected. If I am deleting all the rows without WHERE (some_conditon), rollback is not working.

        Please let me know what is the problem.

        THANKS IN ADVANCE. Moorthy
(moorthy_at_eng.auburn.edu)

---
:=)  Do unto others as you would wish to be done by others.  :=)