When using DataBase Configuration Assistant, there will be an error on the process of creating database!
ORA-00922:missing or invalid option
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. |
All references to this error I've seen on the web point to a mal-formed SQL statement. I ain't writing any SQL here.
the app asking for the password doesn't seem to be smart enough to tease out bad characters.
i use the password my name follow a random number, and it passed!
When using DataBase Configuration Assistant, there will be an error on the process of creating database!
ORA-00922:missing or invalid option
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. |
All references to this error I've seen on the web point to a mal-formed SQL statement. I ain't writing any SQL here.
the app asking for the password doesn't seem to be smart enough to tease out bad characters.
i use the password my name follow a random number, and it passed!