title: Creating this table in oracle 10g
body: <p>This table is not creating in oracle 10g and I dont know why, the code is </p>
  
  <pre><code>     CREATE TABLE  "shift" 
    ( 
     SHIFT_DATE DATE, 
     OPERATOR1 VARCHAR2(30),
     ENGINEER VARCHAR2(30),
     ENGINEER2 VARCHAR2(30),
     MANAGER VARCHAR2(30),
     SHIFT VARCHAR2(5),
   PRIMARY KEY (SHIFT_DATE) ENABLE, 
   FOREIGN KEY (MANAGER)
    REFERENCES  SHIFT_MNG (MANAGER) ENABLE
     FOREIGN KEY (SHIFT)
    REFERENCES  SHIFT_TYPE (SHIFT) ENABLE
        );
  </code></pre>
  
  <p>the Error message i get is</p>
  
  <pre><code>   ORA-00907: missing right parenthesis
  </code></pre>
  
  <p>Any help would be greatly appreciated</p>
  
  <p>Thanks</p>