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 & long-running query

Re: DDL & long-running query

From: <tim.kearsley_at_milton-keynes.gov.uk>
Date: 12 May 2005 06:08:54 -0700
Message-ID: <1115903334.012621.139690@g49g2000cwa.googlegroups.com> 





And have you actually tried running this test?  You'll find the DROP
COLUMN on a table with 100,000,000 rows takes a *very* long time to
complete because of the undo it generates.



All the testing I've done this morning indicates that an ALTER TABLE
does NOT wait for a query to complete.



Tim Kearsley


HBS Milton Keynes
Received on Thu May 12 2005 - 08:08:54 CDT












Original text of this message













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