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 -> Please help!!!!!!!!

Please help!!!!!!!!

From: Alexander Bozhik <sander_at_isd.donin.com>
Date: Wed, 08 Sep 1999 22:38:30 +0300
Message-ID: <37D6BB36.8A4A4C45@isd.donin.com>


Hi all,
I have two databases with equel logical structure (Oracle8.0.4 , NT4 SP3). Both of them have the table DOCUMENT. The only difference is quantity of records in DOCUMENT- 7000 and 14000 respectively.  I tried out to do such script :
ALTER TABLE DOCUMENT ADD ( TST CHAR(1) DEFAULT 'N' NULL) ; In the first case (7000 records) it was OK. In the second case (14000 records) I've got the message: ORA-01422: exact fetch returns more than requested number of rows .
How is that ?
SY,
Alexander Bozhik Received on Wed Sep 08 1999 - 14:38:30 CDT

Original text of this message

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