Using restore points

Hello folks.

In many cases you probably need to restore a database to a point in the past.
Errors that won’t be reversed only with a flashback table or perhaps you do not have
the flashback feature configured for the database.

You can use restore point with a specific time in the past or using the SCN number.
To capture the SCN of the database you can the query below:

Continue reading