Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2010

    Unanswered: How can undo commited data.

    Hi everyone.

    I am newbie. i have problem here. Just now i have commit the "update" transaction in database. So the new data was written replacing the old data.

    How can i undo the transaction? I cannot used the rollback bcause i have commit it. How can i do so that i get back the old data?

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 23
    If you are using enterprise edition and the commit is not too long ago and your DBA has configured a sensible undo retention time and you have the necessary privileges, you might be able to restore the data using a flashback

    Details and examples are in the Oracle's SQL Reference:

  3. #3
    Join Date
    Jul 2003
    as mentioned. contact the DBA and give him the exact time of the update to see if they can do a flashback query to restore the data.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Tags for this Thread

Posting Permissions

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