--查询账号状态
select account_status from dba_users where username='TEST';
--密码被重用次数改成不限制
ALTER PROFILE DEFAULT LIMIT PASSWORD_REUSE_MAX UNLIMITED;
--修改密码
alter user TEST identified by dhn_67#12;
--解锁
alter user TEST account unlock;
--恢复密码被限制5次
alter profile DEFAULT limit PASSWORD_REUSE_MAX 5;