Re: DDL & long-running query

John wrote:

> Hi all,
>
> I am not sure how to answer this question:
> "What happens if you run a DDL, say alter table, on a table currently
> being accessed by a long-running query?"
>
> Would the query fail?
>
>
> John

The ALTER TABLE hangs until it can obtain the required lock.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)