Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01758 – table must be empty to add mandatory (NOT NULL) column

Oracle Database Error Code ORA-1758 Description :

table must be empty to add mandatory (NOT NULL) column

Error Cause:

It is not possible to define a new column as NOT NULL if rows already exist in the table being modified.

How to Solve :

Retry the statement without the NOT NULL specification.