ORA Database Error Messages ORA-01758: table must be empty to add mandatory (NOT NULL) column June 11, 2015 mpbod ORA-01758: table must be empty to add mandatory (NOT NULL) column Cause: It is not possible to define a new column as NOT NULL if rows already exist in the table being modified. Action: Retry the statement without the NOT NULL specification. Back to previous menu https://support.oracle.com/ http://www.oracle.com/ Share this:Click to email a link to a friend (Opens in new window)Click to print (Opens in new window)Click to share on Facebook (Opens in new window)Click to share on LinkedIn (Opens in new window)Click to share on Tumblr (Opens in new window)Click to share on Twitter (Opens in new window)Click to share on Pinterest (Opens in new window)Click to share on Reddit (Opens in new window)Click to share on Pocket (Opens in new window)