Flashback – Part 7 (Flashback Data Archive)

Hey everyone,

Finally, the last part of our flashback posts, FLASHBACK DATA ARCHIVE! If you didn’t have a chance to check the previous posts, please do not hesitate to take a look if you need or if you just get curious.

Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 6 (Flashback Database)

Well, there we go then 🙂

Continue reading

Flashback – Part 6 (Flashback Database)

Hi people,

We’re almost there to finish this Flashback Tutorial 🙂

To check the previous posts, please go through:

Flashback – Part 1 (Flashback Drop)
Flashback – Part 2 (Flashback Query)
Flashback – Part 3 (Flashback Versions Query)
Flashback – Part 4 (Flashback Transaction Query)
Flashback – Part 5 (Flashback Table)
Flashback – Part 7 (Flashback Data Archive)

Today’s post is gonna be about Flashback Database, a pretty good feature for non-production levels of your structure, I would say.

It’s very unlikely that you are going to rollback your entire production database to a point-in-time in the past, right? But if you need to, this facility is there.

Why do I say that it is great for non-production environments?
Continue reading