locked
retrive deleted records in oracle RRS feed

  • Question

  • User-1141190189 posted

    I have deleted some records from a table before 4 days, and i need to recover it.

    is there any way in oracle to retrieve them, i tried flashback query but an error message appears saying that "old snapshot"

    any help please

    Wednesday, December 16, 2015 8:52 PM

All replies

  • User269602965 posted

    Did you check the recycle bin?  Drop table without PURGE and it might be there.

    Did you try flashback with the "to before drop" option

    SQL> flashback table {tablename} to before drop;

    Do you have archive logging enabled?  If so, you can use Log Miner procedures to recover deleted tables. (some reading required).

    What is your backup schedule to Oracle DMP files?  I do full DB backup every night and keep 7 nights in case the above are not helpful.

    Do you have Oracle support contract?  They are helpful.  I even called them on Christmas to fix a database boot failure issue.

    Thursday, December 17, 2015 12:59 AM