Re: allowing developers to create guaranteed restore point

From: rjamya <>
Date: Tue, 3 Dec 2013 14:30:50 -0500
Message-ID: <>


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.


Received on Tue Dec 03 2013 - 20:30:50 CET

Original text of this message