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 -> DROP COLUMN uses rollback?

DROP COLUMN uses rollback?

From: Stephen B <stephen.bell_at_cgi.ca>
Date: Wed, 5 Jun 2002 09:45:19 -0400
Message-ID: <LEoL8.6678$W74.1398920@news20.bellglobal.com> 





Hi all,



I've been trying to drop a column in a fairly large table I have (alter
table xx drop column yy)


After each of two initial attempts at this I received an "unable to extend
rollback segment nn" error...



There appear to be no active transactions so it seems that my transaction is
causing the rollback...



I didn't think a DDL statement would do this?



Any thoughts appreciated,



Steve
Received on Wed Jun 05 2002 - 08:45:19 CDT












Original text of this message













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