0ra-00922: 丢失或者无效的选项 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.
案例一：oracle明文密码漏洞] 受影响系统： oracle oracle10g application server 9.0.4.0 oracle oracle10g application server 10.1.0.2 描述： -------------------------------------------------------------------------------- oracle database是一款商业性质大型数据库系统。 oracle 10g存在包含明文密码的全局可读文件，本地攻击者可以利用这个漏洞获得对数据库的访问。 sysman帐户的密码可在’$oracle_home/hostname_sid/sysman/config/emoms.properties’文件中获得，此文件全局可读。 另外如果安装oracle 10g时提供sys, system, dbsnmp和sysman 帐户密码相同，并且密码有惊叹号(如f00bar!!)，那么当设置sysman和dbsnmp密码时db安装会出现错误，错误信息 "postdbcreation.log"会记录密码： alter user sysman identified by f00bar!! account unlock error at line 1: ora-00922: missing or invalid option alter user dbsnmp identified by f00bar!! account unlock error at line 1: ora-00922: missing or invalid option <*来源：david litchfield （[email protected]）