DataBase Configuration Assistant

最新推荐文章于 2025-09-09 20:29:32 发布

原创最新推荐文章于 2025-09-09 20:29:32 发布 · 1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #constraints #random #null #sql #action

Oracle 专栏收录该内容

4 篇文章

订阅专栏

使用数据库配置助手创建数据库时出现ORA-00922错误，网络上该错误多指向格式错误的SQL语句，但此处未编写SQL。问题可能是要求输入密码的应用无法识别不良字符，使用姓名加随机数作为密码后问题解决。

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!