DataBase Configuration Assistant

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

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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!

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值