日期:2014-05-17 浏览次数:21103 次
-- 用户名用双引号括起来,同时注意 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