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

Home -> Community -> Usenet -> c.d.o.server -> Re: Q:alter table and rollback problem - urgent

Re: Q:alter table and rollback problem - urgent

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 04 Mar 2004 23:21:24 +0100
Message-ID: <ctaf40potqpl7vevudvpgv1d0f7qsgbfda@4ax.com> 





On Thu, 04 Mar 2004 21:59:54 +0000, Andy Hassall <andy_at_andyh.co.uk>
wrote:



> 

> Exactly - DDL does a commit both before and after, so it's not the same

>transaction as the one that had its rollback segment set.




And as it is DDL it will use the SYSTEM rollback segment by default.
The set transaction statement of the OP is useless.



--
Sybrand Bakker, Senior Oracle DBA


Received on Thu Mar 04 2004 - 16:21:24 CST












Original text of this message













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