Re: sorry for duplicating this message (ORA-01422 when altering table)

OK - found the problem...

it turn out there is a trigger on update for this table .... so the tables kind-of locked herself ...

it generated "dead-lock" message in the trace file ...

so just
disable trigger
make the change
enable back.

thanks for trying to help....

dorit

DA Morgan wrote:
> dorit wrote:
> > i posted the following message in another gorup - but maybe someone
> > here knows the answer ?
> >
> > thanks !
> >
> > ***********************************
> >
> > oracle 9.2.0.1
> >
> > i'm trying to add not null coulmn to existing table.
> >
> >
> > i'm running :
> > ALTER TABLE tbtat ADD (TCLASSID INTEGER default 22 not null);
> >
> >
> > and i'm getting :
> > ORA-01422: exact fetch returns more than requested number of rows
> >
> >
> > any idea why ?
> >
> >
> > ********************************************************
>
> SQL*Plus: Release 10.2.0.2.0 - Production on Thu Aug 31 14:35:21 2006
>
> Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
>
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Productio
> With the Partitioning, OLAP and Data Mining options
>
> SQL> ALTER TABLE servers
> 2 ADD (TCLASSID INTEGER default 22 not null);
>
> Table altered.
>
> SQL>
>
> No. But based on the error message I don't think you typed anything
> even remotely related to what you've posted. An ORA-01422 is something
> to expect from:
>
> SELECT lots_of_stuff
> INTO x
> FROM t;
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org
Received on Thu Aug 31 2006 - 16:49:33 CDT