Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help!!!!!!!!
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