Re: Help: Problems with ALTER TABLE
Date: Fri, 18 Jul 2003 12:01:13 +0200
Message-ID: <bf8gh9$af2$1_at_pentheus.materna.de>
Hi Steffen,
this is possible, if you have a second session, which updates the table after (1). The second session hangs than and you recieve ORA-00054 in the first one, doing (1).
Regards
Elena
"Steffen Krippner" <steffenkrippner_at_yahoo.com> schrieb im Newsbeitrag
news:8a219c99.0307180131.51d09222_at_posting.google.com...
> Hi,
> the problem I am facing is a little different:
>
> 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;
> 2) alter table t add (xxx number(10,0));
>
> Result:
> After (1) the updates off session A come to a halt. (Obviously fine)
> After (2) I get ORA-00054.
>
> Any explanations?
>
> Thanks.
> Steffen
Received on Fri Jul 18 2003 - 12:01:13 CEST