I was trying to add a new field in an Oracle DB table using this script:
alter table TABLENAME add FIELDNAME char(1) not null default '0' ;
it was throwing an error:
'ORA-30649:missing directory keyword'
it drove me nutts for a while and after some googling, I was able to figure it out, its the Order: 'not null' should come after default value. right script is:
alter table TABLENAME add FIELDNAME char(1) default '0' not null;
order does matter :)