Re: allowing developers to create guaranteed restore point

We do this using external job. restore point is taken via a shell script, this shell script is called via dbms_scheduler job. If you set it up like this, you can give execute on a procedure (in sys schema) to developers. This procedure will run the scheduler job and your requirements will be met.

We recently extended this to our release management, it takes a restore point before release begins, so if something goes wrong, we have that restore point as a failback. Since it is all automated via liquibase, it is hands off for us.

Raj

--
http://www.freelists.org/webpage/oracle-l