Tag: ora-01758
ORA-01758 when trying to alter table
If you are trying to add a new Not NULL columns to a table and you get the following error:
ORA-01758: table must be empty to add mandatory (NOT NULL) column
Since the values in the new column are null (after all, you just added the column) the new constraint can not be satisfied.
There are several [...]
Posted: January 6th, 2009 under Oracle.
Tags: alte table, ora-01758, Oracle
Comments: none