ORA-00922 Missing or Invalid Option

[Yew12]

Hi,

Does anyone know why I get this error when I run this script.

 
Create table ROOM
(ROOM_ID number(4),
PROPERTY_ID number(4) Not Null,
ROOM_TYPE char(15) Not Null,
HEATING char(3) Not Null,
FURNISHED char(3) Not Null,
DIMENSIONS char(11) Not Null,
SPECIAL_FEATURES char(30) Null,
Primary Key(ROOM_ID,PROPERTY_ID),
Constraint PROPERTY_ID_FK Foreign Key(PROPERTY_ID) References PROPERTY(PROPERTY_ID),
Constraint Room_Type_CK Check(ROOM_TYPE in('Reception room','Bathroom','Bedroom','Utility','Kitchen')),
COnstraint Heating_CK Check(HEATING in('Yes','No')),
Constraint Furnished_CK Check(FURNISHED in('Yes','No')));
 

Thanks very much in advance.

[amitpatel66]

I do not face any issue:

 
SQL> Create table ROOM
  2  (ROOM_ID number(4),
  3  PROPERTY_ID number(4) Not Null,
  4  ROOM_TYPE char(15) Not Null,
  5  HEATING char(3) Not Null,
  6  FURNISHED char(3) Not Null,
  7  DIMENSIONS char(11) Not Null,
  8  SPECIAL_FEATURES char(30) Null,
  9  Primary Key(ROOM_ID,PROPERTY_ID),
 10  Constraint PROPERTY_ID_FK Foreign Key(PROPERTY_ID) References PROPERTY(PROPERTY_ID),
 11  Constraint Room_Type_CK Check(ROOM_TYPE in('Reception room','Bathroom','Bedroom','Utility','Kit')),
 12  COnstraint Heating_CK Check(HEATING in('Yes','No')),
 13  Constraint Furnished_CK Check(FURNISHED in('Yes','No')))
 14  /
 
Table created.
 
SQL> 
 
 
 
 

[Yew12]

Thank you for your response we know think its the order in which we have created the tables.

Thanks

[amitpatel66]

Thank you for your response we know think its the order in which we have created the tables.

Thanks

You need to have your property table in palce before creating ROOM table. But this does not display error like invalid option or something, it will say property table or view does not exist.

[Priyanka17]

Hi ,

I have got the same Error.
ORA-00922 Missing or invalid option .
While creating first database while installation.
Will you please assist me on this error?

Thanks in advance.

Regards,
Priyanka

[debasisdas]

Kindly Post Your Code That You Are Working On.

[samir pradhan]

Hi ,

I have got the same Error.
ORA-00922 Missing or invalid option .
While creating first database while installation.
Will you please assist me on this error?

Thanks in advance.

Regards,
Priyanka

Hi Priyanka.

i m confused that u got the error while installation.
as i know

ORA-00922 Missing or invalid option, causes due to syntax error.

specifying a maximum length on a date or long datatype also
causes this error.

or like Yew12's case where Yew12 was trying to create the ROOM table first before creating PROPERTY table also causes this error.


Correcting the syntax may help u to overcome from the error.