In 11g there are two major enhancements to restore points
1. Create restore point as of scn, until 10g you can create a restore point with current scn only
SQL> create restore point p1 as of scn 19393930;
2. Preserve the restore points
SQL> create restore point p1 preserve;
The second point above need […]
Follow Me!!!