My Oracle Support Banner

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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.