Re: Help: Problems with ALTER TABLE
From: Alan Mills <Alan.Mills_at_xservices.pants.fujitsu.com>
Date: Fri, 18 Jul 2003 11:12:43 +0100
Message-ID: <bf8h80$5ac$1_at_news.icl.se>
Date: Fri, 18 Jul 2003 11:12:43 +0100
Message-ID: <bf8h80$5ac$1_at_news.icl.se>
"Steffen Krippner" <steffenkrippner_at_yahoo.com> wrote in message
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.
>
Not having memorised every oracle error code. remind me what error 54 is please. Received on Fri Jul 18 2003 - 12:12:43 CEST