Re: rollbacks

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 13 Apr 2006 22:42:04 -0700
Message-ID: <1144993324.441089.225540@v46g2000cwv.googlegroups.com>

arch wrote:
> Is there any way to rollback DDL (and not just DML).

No. DDL commits immediately before itself and immediately after itself, this is by design and cannot be changed. The only ways to undo DDL are to DROP created objects or revert the changes with another DDL, or to perform an incomplete recovery to a point in time just before the DDL was executed (flashback may also help in some cases.)

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Fri Apr 14 2006 - 00:42:04 CDT