Scenario: Trying to reset to the existing password throws following error.
ERROR at line 1:
ORA-28007: the password cannot be reused
Solution: Check the user profile set for the user. Check for the existence of a password verify function in the profile. Set the password_verify_function to NULL Another reason could be that the PASSWORD_REUSE_MAX limit has reached. If so set to a higher value or to UNLIMITED […]