日期:2014-05-17  浏览次数:20867 次

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.13
sys@TDODS> alter user a-admin account unlock;
alter user a-admin account unlock
            *
ERROR at line 1:
ORA-00922: missing or invalid option


Elapsed: 00:00:00.00
sys@TDODS> select username, account_status from dba_users where username='a-admin';

USERNAME               ACCOUNT_STATUS
------------------------------ --------------------------------
a-admin                OPEN

Elapsed: 00:00:00.00
sys@TDODS> alter user "a-admin" account unlock;

User altered.

Elapsed: 00:00:00.01
sys@TDODS> select username, account_status from dba_users where username='a-admin';

USERNAME               ACCOUNT_STATUS
------------------------------ --------------------------------
a-admin                OPEN

Elapsed: 00:00:00.00