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

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