CDS-15007, ORA-01758 and CDS-11007 when Adding a Column to a Table Which is not Empty
Last updated on OCTOBER 27, 2016
Applies to:Oracle Designer - Version: 6.5 to 9.0.2
This problem can occur on any platform.
"Checked for relevance on 10-Oct-2007"
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)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms