ORA-30649: missing DIRECTORY keyword

alter table TABLENAME add FIELDNAME char() not null default '0'  ;

it was throwing an error:

'ORA-:missing directory keyword'


solution:
 put NOT NULL after the default '0'
           

http://stackoverflow.com/questions/12873667/alter-table-syntax