Online Documentation for SQL Manager for Oracle

Adding restore point

You can add a restore point before changing the data, to get possibility to flash back to the current data state.

Click the iconAddRestorePoint Add restore point item of the Navigation bar or toolbar to open the Add restore point dialog:


Appendix - Add Restore Point



Date and time when the restore point was created. This field can't be modified.



System Change Number - the unique number of the restore point. The value is generated automatically and can't be modified.



Define the restore point name at this field.


Store in

The RadioButton Built-in DBMS restore point table is available in Oracle 10 and higher. The alternative RadioButton EMS Manager restore point table allows you to create the restore point in Oracle 9 too.