Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007
    Posts
    14

    Unanswered: how can i'm Rollback

    I have performed a COMMIT operation.But I want to rollback the same.Is there any timestamp in which i can perform the ROLLBACK after COMMIT.

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Oracle allows you to rollback uncommitted transaction. You may rollback an entire transaction, or part of it (regarding the savepoint you set). Read something more about Savepoints here.

    Also, there's a Flashback feature which will not allow you to rollback a transaction, but might enable you to view past states of database objects (if you find it helpful).

    If you can, restore database to a state before transaction you have committed started and repeat the transaction (but make sure to modify it in order not to commit it again before you really should).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •