Oracle 11g: ORA-00907: missing right parenthesis solution

 Issue:

When you create table using sql like this.

SQL> create table ships
  2  (
  3    ship_id number ,
  4    ship_name varchar2(20),
  5    home_PORT_ID number,
  6    constrain ships_ports_fk foreign key (home_port_id) references ports (po
t_id)
  7  );

You may got following error message after execute.

  constrain ships_ports_fk foreign key (home_port_id) references ports (port_id)

                           *
第 6 行出现错误:
ORA-00907: missing right parenthesis solution

 

Reason:

You may have something misspell.

 

Solution:

Please review your sql code to check if anything is misspelled. E.g. In my case, I misspell "constraint" as "constrain".