Database Design

Oracle "ORA-00922" error

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jul 2008

Posts: 46

Reputation: robertmacedonia is an unknown quantity at this point

Solved Threads: 0

robertmacedonia robertmacedonia is offline

Offline

Light Poster

Oracle "ORA-00922" error

Apr 29th, 2009

Hello, I am trying to run my tables in the Sql Workshop using the Sql Commands option in Oracle, and I get this error - "ORA-00922: missing or invalid option". I read that this is somehow related to the NOT NULL option, but I think this is how my table should look like, and it still gives me an error. So, would you, please, take a look at it.

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE TABLE Izraboteni proekti (
  Primaren_broj NUMERIC(30)   NOT NULL ,
  Kandidat_ID NUMERIC(30)   NOT NULL ,
  Tema VARCHAR(255)    ,
  Ocena NUMERIC(30)      ,
PRIMARY KEY(Primaren_broj, Kandidat_ID),
  FOREIGN KEY(Kandidat_ID)
    REFERENCES Kandidat(Kandidat_ID));
CREATE TABLE Izraboteni proekti (
  Primaren_broj NUMERIC(30)   NOT NULL ,
  Kandidat_ID NUMERIC(30)   NOT NULL ,
  Tema VARCHAR(255)    ,
  Ocena NUMERIC(30)      ,
PRIMARY KEY(Primaren_broj, Kandidat_ID),
  FOREIGN KEY(Kandidat_ID)
    REFERENCES Kandidat(Kandidat_ID));

Last edited by peter_budo; May 6th, 2009 at 3:13 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.