Database Reference
In-Depth Information
EM Database Control also provides the feature of Flashback
Table. Under Maintenance tab, it can be accessed by clicking the
Perform Recovery link.
Figure 10-65: Use Oracle Enterprise Manager Database Control to
enjoy Flashback Table feature. Its available on Perform Recovery page.
Flashback Query
Oracle Flashback Query enables us to see the data inside the
table as it existed in the prior point in time. Before running a
Flashback Query, make sure that the database is running under
Automatic Undo Management and you have set the
UNDO_RETENTION initialization parameter. Moreover, set the
undo tablespace with RETENTION GUARANTEE option, this
will make sure nothing gets over written in case undo tablespace
gets full before UNDO_RETENTION period.
Search WWH ::
Custom Search