CODEWITHSUNDEEP
sqloracle-databaseoracle11gundoflashback
Viplove Sharma
Viplove Sharma

Reputation: 1

Records Deleted. Commit executed. Can we have that records back from anywhere?

Recovered Records Should be up to date as when they were deleted.

Upvotes: 0

Views: 831

Answers (1)

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

You could make use of the FLASHBACK QUERY.

I answered a similar question here https://stackoverflow.com/a/27309814/3989608

You could go back as far as depending on the settings of the UNDO_RETENTION parameter.

A quote from T.Kyte regarding flashback query:

flashback query has been enabled in the database for many many many years.
We call it Multi-versioning and it gives us our consistent read and non-blocking reads.

That means -- you've been doing flashback query for years.

You do not need to "enable it", it is an intrisic feature/function of the database that you cannot in any way "disable"!

It is ALWAYS on.

Link from AskTom https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:6135698985750

Upvotes: 2

Related Questions