ORA-28002: thepassword will expire within 172day

1. alter profile default limit password_life_time unlimited;

 

注意要修改一次密码后就生效了

 

2.alter profile test limit PASSWORD_LIFE_TIME 60 ;