Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle transactions and DDL statements.
"Vladimir M. Zakharychev" <bob--nospam--_at_dynamicpsp.com> wrote in message
news:e3shfa$23hn$1_at_hypnos.nordnet.ru...
>
> Pardon my ignorance, but is it really possible to rollback a
> CREATE TABLE in MS SQL Server??? I am not sure
> how DDL affects your current transaction in MSSQL,
> maybe it runs DDL autonomously, but afaik you can't
> rollback DDL in MSSQL, too.
>
Actually it looks like I'm wrong and it's doable within
BEGIN TRAN..END TRAN block. Amazing. I wonder
how they manage to rollback an ALTER TABLE of
a big existing table....
-- Vladimir M. Zakharychev N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.comReceived on Wed May 10 2006 - 06:30:04 CDT