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: Thomas Kellerer <BDHLDUUTPRWS_at_spammotel.com>
Date: Wed, 10 May 2006 14:11:13 +0200
Message-ID: <4ce3j1F1551mqU1@individual.net>


On 10.05.2006 13:30 Vladimir M. Zakharychev wrote:
> 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....

Well actually there *is* an Oracle database that requires a COMMIT for a DDL: rdb

At least it was implemented that way when it still was called rdb/VMS (or was it VAX/rdb?) and was still owned by Digital Equipment.

Thomas

-- 
It's not a RootKit - it's a Sony
Received on Wed May 10 2006 - 07:11:13 CDT

Original text of this message

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