oracle account unlock code example
Example 1: oracle unlock user
-- Unlock a user
ALTER USER my_user ACCOUNT UNLOCK;
-- If password is expired
ALTER USER my_user IDENTIFIED BY new_password ACCOUNT UNLOCK;
Example 2: oracle unlock account
ALTER USER "MY_SCHEMA_NAME" ACCOUNT UNLOCK;