Xref: alice comp.databases.oracle.server:65213
Path: alice!news-feed.fnsi.net!netnews.com!feed2.nntp.acc.ca!feed.nntp.acc.ca!news.ican.net!not-for-mail
From: John Chiu <johnymc@netscape.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Please help!!!!!!!!
Date: Thu, 09 Sep 1999 20:51:50 -0400
Organization: ICAN.Net Customer
Lines: 25
Message-ID: <37D85626.7B567BEC@netscape.com>
References: <37D6BB36.8A4A4C45@isd.donin.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.04 [en] (WinNT; I)

Do you have any update trigger defined ? You may have a select statement in
your trigger.
Add a column in the table will fire up that (before/after)update trigger.
try disable the trigger before adding the column.

John Chiu
johnc@relsol.com

Alexander Bozhik wrote:

> 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