Nooby

Im new to sql in Oracle and i hope i have posted this in the correct forum. Im trying to create a new table but not having any luck and i would be greatful if somebody could point me in the right direction. create table global_locations(id number(6)CONSTRAINT id_global_locations_id NOT NULL, name VARCHAR2(25), date_opened date, address VARCHAR2(50), city VARHCAR2(25), zip/post_code VARCHAR2(10), phone VARCHAR2(20), email VARHCAR2(30), manager_id VARCHAR2(6), emergency_contact VARCHAR2(30), CONSTRAINT global_locations_id_uk UNIQUE(id,manager_id)); Error ORA-00907: missing right parenthesis I have checked and for the life of me can't see the problem. Thanx in advance for any help and again im sorry if this is in the wrong place or format.