RMAN Restore and Recovery - Oracle RMAN for Absolute Beginners - page 178

In this scenario, you have to rename the index:
SQL> alter index "BIN$BCRjF6KQbi/gU7fQTwrP+Q==$0" rename to inv_pk;
You also have to rename any trigger objects in the same manner. If referential constraints were in place before the
table was dropped, you must manually re-create them.
If, for some reason, you need to flash back a table to a name different from the original name, you can do so as
follows:
SQL> flashback table inv to before drop rename to inv_bef;
Flashing Back a Table to a Previous Point in Time
If a table was erroneously deleted from, you have the option of flashing back the table to a previous point in time. The
Flashback Table feature uses information in the undo tablespace to restore the table. The point in time in the past
depends on your undo tablespace retention period, which specifies the minimum time that undo information is kept.
If the required flashback information isn't in the undo tablespace, you receive an error such as this:
ORA-01555: snapshot too old
In other words, to be able to flash back to a point in time in the past, the required information in the undo
tablespace must not have been overwritten.
FLASHBACK TABLE TO SCN
Suppose you're testing an application feature, and you want to quickly restore a table back to a specific SCN. As part of
the application testing, you record the SCN before testing begins:
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
4760099
You perform some testing and then want to flash back the table to the SCN previously recorded. First, ensure that
row movement is enabled for the table:
SQL> alter table inv enable row movement;
SQL> flashback table inv to scn 4760089;
The table should now reflect transactions that were committed as of the historical SCN value specified in the
FLASHBACK statement.
FLASHBACK TABLE TO TIMESTAMP
You can also flash back a table to a prior point in time. For example, to flash back a table to 15 minutes in the past, first
enable row movement, and then use FLASHBACK TABLE :
SQL> alter table inv enable row movement;
SQL> flashback table inv to timestamp(sysdate-1/96) ;