How to drop Non Null constraint in Oracle ?

See CHECK constrains on your column

Select * From All_Constraints Where Table_Name like '%NON_SYSTEM%'


Remove NOT NULL from table
Alter Table Non_System_Cords Modify cord_guid Null;

Remove Constraint with Class Name
alter table Non_System_Cords drop constraint SYS_C0022148