CDS-15007, ORA-01758 and CDS-11007 when Adding a Column to a Table Which is not Empty
(Doc ID 275726.1)
Last updated on OCTOBER 27, 2016
Applies to:
Oracle Designer - Version: 6.5 to 9.0.2This problem can occur on any platform.
Server Generator
"Checked for relevance on 10-Oct-2007"
Symptoms
You have added a new column to a table. This column is mandatory (NOT NULL).Now you generate the table from Designer to add this new column to your table in the database.
The creation fails with the following errors:
CDS-15007 Error: (Oracle error) ORA-01758: table must be empty to add mandatory (NOT NULL) column CDS-11007 Error: (SQL execution error ) line 6: ALTER TABLE <table name> ADD (<column name> <datatype> NOT NULL)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms
Cause
Solution