Re: Help: Problems with ALTER TABLE
From: Steffen Krippner <steffenkrippner_at_yahoo.com>
Date: 20 Jul 2003 23:11:28 -0700
Message-ID: <8a219c99.0307202211.766b1f8a_at_posting.google.com>
Date: 20 Jul 2003 23:11:28 -0700
Message-ID: <8a219c99.0307202211.766b1f8a_at_posting.google.com>
Hi,
Thanks,
thanks for helping- but I still do not get it. I do the "lock table"
in the first session. After that the updates in the second session
stop. That is fine since the first session got the table lock. When I
do the "Alter Table" in the first session it fails with the 00054
error "resource busy". Shouldn't this succeed since I hold the table
lock already in this session?