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

    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
    Posts
    2,935
    Provided Answers: 12
    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:
    http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_9012.htm#i2172752

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    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
  •