CODEWITHSUNDEEP
sqloracle-databasesqlplusrollback
Caffeinated
Caffeinated

Reputation: 12484

Can I undo a rollback in sqlplus?

I somehow thought rollback means undo the last action. This is what I did:

SQL> update owns
  2  set DRIVER_ID=99999999
  3  ^[[A^Z;

4 rows updated.

SQL> select * from owns;

DRIVER_ID            LICENSE
-------------------- ----------
99999999             ABC222
99999999             MSA369
99999999             MZZ2828
99999999             ZGA123

SQL> rollback
  2  ;

Rollback complete.

SQL> select * from owns;

no rows selected

Is everything gone forever? All my data too? Thanks for any advice and help

Upvotes: 0

Views: 6346

Answers (1)

Yahia
Yahia

Reputation: 70369

what you show is not complete... before that UPDATE you must have done something else like an INSERT...

There is no rollback of the rollback if that is what you are asking... the only way you will get this "undone" is to re-execute all statements executed between the last commit before the rollback and that rollback (in the same order!)...

Another option would exist IF your Oracle DB has an active Flashback area - then you could "rewind" the whole DB to the point in time just before you issued the rollback...

Upvotes: 4

Related Questions