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