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.

��

Burleson is the American Team

Note:This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.

Verify
experience!Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.

Errata? Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just e-mail:
and include the URL for the page.