Tag Archives: ORA-01758

ORA-01758: table must be empty to add mandatory (NOT NULL) column

While adding NOT NULL column into a table, the below error occurred: SQL> Alter table CM_ODS_DWN_STG add MATCH_EVT_ID  CHAR(12) NOT NULL; Alter table CM_ODS_DWN_STG add MATCH_EVT_ID  CHAR(12) NOT NULL             * ERROR at line 1: ORA-01758: table must be empty … Continue reading

Posted in ORA- ERRORS | Tagged , | Leave a comment