sql wrong? missing left parenthesis error?

From: Sandy <sandytschaefer_at_hotmail.com>
Date: 18 Nov 2002 09:54:40 -0800
Message-ID: <1e05aa4d.0211180954.7f995291@posting.google.com>

I can't see anything wrong with this sql statement but SQL*Plus doesn't seem to like it. Anyone else see something wrong?

---

SQL> ed
Wrote file afiedt.buf

  1     CREATE TABLE kodUserSession (
  2             SessionID               
  3             UserID                  
  4                     foreign key User
  5             LogonStamp              
  6             LogoffStamp             
  7             IPAddress               
  8     constraint kodUserSession_PK PRI
  9     )

 10* tablespace KOD_DATA
 11 /

                        foreign key User
                                    *

ERROR at line 4:
ORA-00906: missing left parenthesis

---

Received on Mon Nov 18 2002 - 11:54:40 CST