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: DDL/DML and rollback

Re: DDL/DML and rollback

From: vertigo <ax178_at_wp.pl>
Date: Sun, 06 Feb 2005 09:35:42 +0100
Message-ID: <cu4l4d$pq0$1@nemesis.news.tpi.pl> 







> 

> Think of it: when your database crashes during drop table, and the DDL

> hasn't been yet automatically committed, shouldn't Oracle be capable

> to rollback the operation?

> 




Ok, but what about truncate:


I found that: 'truncate is a DDL statement and generates no rollback 
information'. What happen when database crashes during truncate table ?



Thanx


Michal
Received on Sun Feb 06 2005 - 02:35:42 CST












Original text of this message













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