ORA-01922: CASCADE must be specified to drop 'username'

This error is issued if someone tries to drop a user when the user to be dropped still has objects. In order to drop the user and all his objects, use;

drop user user_name cascade;

See also other Oracle errors.