Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DDL & long-running query
tim.kearsley_at_milton-keynes.gov.uk wrote:
> 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
Test again.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu May 12 2005 - 18:50:55 CDT