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.2
This 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

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