Skip to Main Content
  • Questions

  • How find deleted row without using flashback

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Manoj.

Asked: February 06, 2017 - 7:40 am UTC

Last updated: February 07, 2017 - 4:28 pm UTC

Version: Oracle 10g

Viewed 1000+ times

You Asked

After commit how to find a deleted row from emp table in oracle?

and Connor said...

It's gone.

Unless you audited the deletion in some way , then you'll need to use one of the flashback techniques

- flashback query
- flashback table
- flashback database
- flashback transaction

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, February 07, 2017 - 5:23 am UTC

hi Connor McDonald..
I didn't required the data. i only want to know which row,i have deleted..
-------
Select * from emp as of timestamp to_timestamp(sysdate-(60/1440))
minus
select * from emp;

Sam Jacob, February 07, 2017 - 2:29 pm UTC


Connor McDonald
February 07, 2017 - 4:28 pm UTC

Sorry to disappoint :-)

Alex, February 07, 2017 - 4:48 pm UTC

It doesn't seem like you understand Flashback well enough to rule it out as a solution. E.g., your followup

"I didn't required the data. i only want to know which row,i have deleted..
-------
Select * from emp as of timestamp to_timestamp(sysdate-(60/1440)) "

Implies that doesn't use flashback, but it does

https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr002.htm

So, try using that. You will need enough undo space and retention though to go back as far as you need to.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.