Oracle Set Password to Never Expire

select username, account_status, EXPIRY_DATE from dba_users order by 1;

select * from dba_users where account_status='OPEN' order by 1;


alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

SELECT * FROM dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';