documentation说：

If you cause a database user’s password to expire with PASSWORD
EXPIRE,then the user (or the DBA) must change the password before
attempting to log into the database following the expiration.

但是，您可以通过将用户密码重置为相同的值将状态更改为OPEN。

根据您的版本和设置，其中一个查询可能会得到您的密码哈希：

select spare4 from sys.user$ where name='[user name]';
select password from dba_users where username = '[user name]';

然后使用它来重置它：

alter user [user name] identified by values '[result from above query]';