Re: Help: Problems with ALTER TABLE

steffenkrippner_at_yahoo.com (Steffen Krippner) wrote in message news:<8a219c99.0307202211.766b1f8a_at_posting.google.com>...
> Hi,
> 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?
>
> Thanks,
> Steffen

No
The situation you have is that your affected table is already in use prior to your ALTER TABLE command. Hence the *table definition* is locked, and you won't be capable to get another lock. You need to make sure no one has the table in use. The V$ACCESS view shows which sessions are using it.

Sybrand Bakker
Senior Oracle DBA Received on Mon Jul 21 2003 - 11:45:02 CEST