Your DBA can by setting your password life time to unlimited.
Thanks for your reply.
But I am trying to set for my own schema. is there any other way I can do it?
select profile from DBA_USERS where username = user
alter profile <profile_name> limit password_life_time UNLIMITED;
select resource_name,limit from dba_profiles where profile= <profile> and resource_name = 'PASSWORD_LIFE_TIME'
Consult DBA before executing these scripts ...
try this ...
If you are not a DBA or do not have DBA priviliges and this is the policy enforced by your DBA, you cannot alter the profile to set your password lifetime unlimited. You must need a DBA privileges. even if you have priviliges, You should not be doing this without asking your DBA because it will affect all the users who are in the same profile.