You must then manually perform either a commit
or a rollback.
Flashback Table
New to Oracle10g, the Flashback Table feature not only restores the state of rows in a table as of
a point of time in the past, but it also restores the table??™s indexes, triggers, and constraints while
the database is online, increasing the overall availability of the database. The table can be restored
as of a timestamp or an SCN. Flashback Table is preferable to other Flashback methods if the
scope of user errors is small and limited to one or very few tables. It??™s also the most straightforward if
you know that you want to restore the table to a point in the past unconditionally. For recovering
the state of a larger number of tables, Flashback Database may be a better choice. Flashback
Table cannot be used on a standby database and cannot reconstruct all DDL operations, such
as adding and dropping columns.
228 Oracle Database 11g DBA Handbook
To use Flashback Table on a table or tables, you must enable row movement on the table
before performing the Flashback operation, although row movement need not be in effect when
the user error occurs. Row movement is also required to support Oracle??™s segment shrink
functionality; because row movement will change the ROWID of a table row, do not enable row
movement if your applications depend on the ROWID being the same for a given row until the
row is deleted. Because none of our applications reference our tables by ROWID, we can safely
enable row movement for the HR tables:
SQL> alter table employees enable row movement;
Table altered.
Pages:
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390