Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle transactions and DDL statements.

Re: Oracle transactions and DDL statements.

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Wed, 10 May 2006 15:30:04 +0400
Message-ID: <e3sirv$240b$1@hypnos.nordnet.ru>

"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.com 
Received on Wed May 10 2006 - 06:30:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US