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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/