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: <sybrandb_at_yahoo.com>
Date: 8 May 2006 08:09:32 -0700
Message-ID: <1147100972.687065.296860@g10g2000cwb.googlegroups.com> 





I don't think that your series of statements constitutes a proper
transaction, as DDL has always been a transaction on it's own, and
probably always will be. Otherwise Oracle is going to compromise
database integrity.



Why do you need DDL in your 'transaction'? in Oracle you don't need
temporary tables.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Mon May 08 2006 - 10:09:32 CDT












Original text of this message













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