Re: DDL & long-running query

I don't believe this is correct. The OP mentioned a long-running QUERY. Surely a query holds no locks and the ALTER TABLE command would therefore complete without any problem?

Tim Kearsley
HBS Milton Keynes

DA Morgan wrote:
> 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)
Received on Wed May 11 2005 - 05:50:12 CDT