现象:
登陆数据库时提示“ORA-28002: the password will expire within XX days”
处理:
登陆SYS命令窗口,执行以下语句
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
解释:
1.查看用户的profile设置:
======================================================
SQL> SELECT username,profile FROM dba_users where username like 'TEST1';
USERNAME PROFILE
------------------------------ ------------------------------
TEST1 DEFAULT
====================&