读书人

oracle提示找不到被锁定用户怎么处理

发布时间: 2012-04-08 14:38:30 作者: rapoo

oracle提示找不到被锁定用户怎么办?
创建了个用户叫: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 

读书人网 >oracle

热点推荐