Flashback Table
Go Up to Available object actions by DBMS
This action builds and submits a FLASHBACK TABLE statement, letting you restore a table to a state at some specified time in the past.
- Note: Before using this object action, consult Oracle documentation for information on restrictions, required permissions, and details on System Change Numbers and Restore Points. For more information, see Accessing Third Party Documentation.
Platform Availability
- ORCL 10g ^
- Note: Available options differ by the version of Oracle that you are working against.
To Restore a Table to Some Previous State
- Initiate a Flashback Table action against a table. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings on the dialog:
| Panel | Settings and tasks | |
|---|---|---|
|
Action Options |
Type |
Lets you select a specific FLASHBACK TABLE clause: BEFORE DROP - If the table is currently in the Recycle Bin, the table will be restored to its state immediately before being dropped. SCN - restores the table to a time corresponding to a specified System Change Number. TIMESTAMP - restores the table to a time corresponding to a specified timestamp value. RESTORE POINT - (10g R2 ^) restores the table to a time corresponding to a specified name associated with an SCN. |
|
SCN |
If you selected a Type value of SCN, type a System Change Number. | |
|
Timestamp |
If you selected a Type value of TIMESTAMP, use this control to provide a timestamp. | |
|
Restore Point (10g R2 ^) |
If you selected a Type value of RESTORE POINT, select a restore point. | |
|
Enable Trigger |
If you selected a Type value of SCN, TIMESTAMP, or RESTORE POINT, selecting this check box overrides the default behavior, ensuring that triggers remain enabled during the flashback process. | |
|
Rename To |
If you selected a Type value of BEFORE DROP, specify a new name for the table being retrieved from the Recycle Bin. | |
|
Dependencies |
For details on using this tab, see Dependencies. | |
|
Preview |
Displays the DDL that will execute the object action. For details, see Preview. | |
- 3. Click Execute. For information on the scheduling option, see Scheduling.