Re: Dangerous ALTER table ...
Posted by:
Jörg Nowak
Date: February 23, 2005 07:13AM
In all table rows of the table colomn which we altered varchar(25) we had the full content length of 50 characters in each row before.
After the alter command ends successfully we had in all fields the content Null. I did not try "show warnings" because it was clear to me what happened.
But I can say the number of warnings (65535) has nothing to do with thew number of rows we altered (1000001). It seems that 65535 is the maximum of warnings (integer size).
But my problem is not the strange number of warnings. My problem is: it should not be possible to execute an "alter table modify / drop " command without a warning before executing this.
Joerg Nowak
Subject
Views
Written By
Posted
3784
February 22, 2005 04:56AM
2258
February 23, 2005 04:38AM
2233
February 23, 2005 04:56AM
2494
February 23, 2005 05:58AM
Re: Dangerous ALTER table ...
2558
February 23, 2005 07:13AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.