Oracle "ORA-00922" error

Expand Post »

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.

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.

robertmacedonia

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

85 posts
since Jul 2008

Permalink

Apr 29th, 2009

Re: Oracle "ORA-00922" error

'Izraboteni proekti' it is not a a valid table name. you should put an underscore (Izraboteni_proekti).

bigakis

Reputation Points: 11

Solved Threads: 2

Newbie Poster

Offline

11 posts
since Apr 2009

Permalink

Apr 30th, 2009

Re: Oracle "ORA-00922" error

I have no idea how I missed that

Thanks a lot ! Greetings.

robertmacedonia

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

85 posts
since Jul 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: why doesnt daniweb has a raima database section?

Next Thread in Database Design Forum Timeline: Survey Database design

DaniWeb Message

Cancel Changes

User Name
Password