创建了个用户叫:a-admin
现在连接数据库,提示此用户被锁定。
于是以system登录,在sqlplus中打alter user a-admin account unlock;结果"-"被认成了option。
后来我加了引号alter user 'a-admin' account unlock;这时候又报“此用户不存在”了。
------解决方案--------------------
- SQL code
-- 用户名用双引号括起来,同时注意 a-admin 用户名的大小写哦:sys@TDODS> create user "a-admin" identified by bee;User created.Elapsed: 00:00:00.13sys@TDODS> alter user a-admin account unlock;alter user a-admin account unlock *ERROR at line 1:ORA-00922: missing or invalid optionElapsed: 00:00:00.00sys@TDODS> select username, account_status from dba_users where username='a-admin';USERNAME ACCOUNT_STATUS------------------------------ --------------------------------a-admin OPENElapsed: 00:00:00.00sys@TDODS> alter user "a-admin" account unlock;User altered.Elapsed: 00:00:00.01sys@TDODS> select username, account_status from dba_users where username='a-admin';USERNAME ACCOUNT_STATUS------------------------------ --------------------------------a-admin OPENElapsed: 00:00:00.00