To unlock a user Run the following sql as administrator user like SYS or SYSTEM
ALTER USER username IDENTIFIED BY 'password' ACCOUNT UNLOCK;
Lock user:
ALTER USER username ACCOUNT LOCK;
Similar Posts:
- How to Enable / Disable Restricted Session in Oracle Database
- How to create Dblink between Oracle & PostgreSQL
- ORA-00020 maximum number of processes exceeded
- How to put oracle database to archivelog
- 15 Oracle Exp Command Examples to Export Database Objects
1,743