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

Re: Please help!!!!!!!!

From: John Chiu <johnymc_at_netscape.com>
Date: Thu, 09 Sep 1999 20:51:50 -0400
Message-ID: <37D85626.7B567BEC@netscape.com>


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_at_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
Received on Thu Sep 09 1999 - 19:51:50 CDT

Original text of this message

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