Skip to main content

What need to do when encounter the error ORA-28001: the password has expired

 When you encounter the error ORA-28001: the password has expired, execute below queries to resolve this.


export ORACLE_SID=<databaseName>

sqlplus / as SYSDBA

SQL> alter profile default limit password_life_time unlimited;

SQL> alter user <userName> identified by <password>;

SQL> commit;

SQL> exit;

Comments

Popular posts from this blog

Get all constraints in Oracle

 To get all the constraints created in Oracle database, use below query.              SELECT * FROM USER_CONSTRAINTS; If you want to get the constraints  created for a particular user then use below SQL query.              SELECT   *   FROM  USER_CONSTRAINTS where owner = 'userName';