Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sorry for duplicating this message (ORA-01422 when altering table)

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

From: dorit <maromdo_at_yahoo.ca>
Date: 31 Aug 2006 13:58:37 -0700
Message-ID: <1157057917.510970.171000@74g2000cwt.googlegroups.com>


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 ?


Received on Thu Aug 31 2006 - 15:58:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US