Set named restore points for easier flashback in Oracle 10gR2

September 1, 2006


Oracle 9i introduced a flashback query feature that displays query results as of a prior point in time. However, the table itself was not modified. Oracle 10g extended the flashback feature to flash back a table permanently. Now Oracle 10g Release 2 makes this process easier with the addition of named restore points.

The article continues at

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers