ORA-00922: missing or invalid option tips Oracle Error Tips by Burleson Consulting

 

The Oracle docs note this on the ora-00922 error*:

ORA-00922 missing or invalid option

Cause: An invalid option was specified in defining a column or storage clause. The valid option in specifying a column is NOT NULL to specify that the column cannot contain any NULL values. Only constraints may follow the datatype. Specifying a maximum length on a DATE or LONG datatype also causes this error.

 

Action: Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.

If an invalid option is specified while defining a storage clause or column, ORA-00922 will be thrown.  ORA-00922 mentions that to specify that the column is not able to contain any NULL values, the valid option while specifying a column is NOT NULL, and solely constraints can follow the datatype.

Also notable to ORA-00922, which can also cause this error to be thrown, is that specifying a maximum length on LOG or DATE datatype.

Correcting ORA-00992 consists of correcting the syntax in your specifications, minding to take out the erroneous option or length specification from the storage of column specification.