This is a 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
|missing or invalid option
|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.
|Correct the syntax. Remove the erroneous option or length specification from the column or storage specification.
We can see the message for correction of the same error is simple that check SYNTAX of executed command and correct it.
Sometimes we can get this error of missing comma (,) or missing bracket () or missing length of long datatypes. Sometimes also get the same error due to invalid datatype define in PL/SQL code. The main and important thing is only that wrong SYNTAX using in coding or SQL execution.
All the best,
Thanks and regards,
Expert Remote DBA team with low-cost remote plans.
When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.
This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.