ORA-00922: missing or invalid option

August 26, 2010 | By

Hi Friends,

This is very tricky and suspenseful error called ORA-00922 with strange detail ORA-00922: missing or invalid option.

This ORA-00922 itself shows only message code missing or invalid option. So many times people are confusing after got this typical Oracle error.

If we check error code from

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.

We can see the message for correction of same error is simple that check SYNTAX of executed command and correct it.

Sometime we can get this error of missing coma (,) or missing bracket () or missing length of long datatypes. Sometime also get same error due to invalid datatype define in PL/SQL code. Main and important thing is only that wrong SYNTAX using in coding or SQL execution.

All the best,

Thanks and regards,

Dbametrix Solutions

Expert Remote DBA team with low cost remote plans.

Be Sociable, Share!

Tags: , , ,

Category: blog, blogging, DBA, oracle troubleshooting

Comments (1)

Trackback URL | Comments RSS Feed

  1. om subhash kumar says:

    please
    give some example.
    for bigneer it is diffecult task