Dangerous ALTER table ...
Posted by:
Jörg Nowak
Date: February 22, 2005 04:56AM
Hello,
we had a simple table with one field cpr varchar(50) and 1 Million entries in the table.
Then we tried altering the table using the following command:
alter table Ptest modify cpr varchar(25);
We got the following message:
Query ok, 1000000 rows affected, 65535 warnings.
Records: 1000000 Duplicates: 0 warnings: 166227
I expected a warning before the change but the query executed successfully and the field has Null values in it. I lost data !
Can the behaviour be changed or is it a bug ?
Joerg Nowak
Subject
Views
Written By
Posted
Dangerous ALTER table ...
3782
February 22, 2005 04:56AM
2258
February 23, 2005 04:38AM
2232
February 23, 2005 04:56AM
2492
February 23, 2005 05:58AM
2557
February 23, 2005 07:13AM
Sorry, you can't reply to this topic. It has been closed.
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.