top of page
CerebroSQL

Oracle:

CREATE RESTORE POINT

CREATE RESTORE POINT restore_point
[ AS OF {TIMESTAMP | SCN} expr ]
[ PRESERVE
| GUARANTEE FLASHBACK DATABASE
];

example

CREATE RESTORE POINT good_data;
FLASHBACK TABLE employees TO RESTORE POINT good_data;

bottom of page