Re: Help: Problems with ALTER TABLE
From: Steffen Krippner <steffenkrippner_at_yahoo.com>
Date: 18 Jul 2003 02:31:41 -0700
Message-ID: <8a219c99.0307180131.51d09222_at_posting.google.com>
Date: 18 Jul 2003 02:31:41 -0700
Message-ID: <8a219c99.0307180131.51d09222_at_posting.google.com>
Hi,
Session A is doing updates on the table.
In Session B (AUTOCOMMIT OFF) I issue the following commands:
1) lock table t in exclusive mode;
Result:
the problem I am facing is a little different:
2) alter table t add (xxx number(10,0));
After (1) the updates off session A come to a halt. (Obviously fine)
Any explanations?
Thanks.
Steffen
Received on Fri Jul 18 2003 - 11:31:41 CEST