数据库先登录到sys 账户下,
找到apex开头的对应的账户,我的是apex_2020
对应代码如下:
-- 1 查询对应的admin账户
select * from Apex_2020.Wwv_Flow_Fnd_User where User_Name = 'ADMIN' ;
-- 2 先解锁 对应字段*ACCOUNT_LOCKED*
update Apex_2020.Wwv_Flow_Fnd_User set ACCOUNT_LOCKED = 'N' WHERE User_Name = 'ADMIN' ;
--3 随便找一个其他有效的,记住密码的工作区,你能找到的对应的密码,粘贴出来
select User_Name ,WEB_PASSWORD,WEB_PASSWORD2 from Apex_2020.Wwv_Flow_Fnd_User where ACCOUNT_LOCKED = 'N' ;
/*WEB_PASSWORD,WEB_PASSWORD2 看你哪个不为空,就代表的你用的是那个密码*/
-- 4.开始 修改密码
-- 4.1 WEB_PASSWORD
update Apex_2020.Wwv_Flow_Fnd_User set WEB_PASSWORD = ’*******粘贴的密码***‘ WHERE User_Name = 'ADMIN' ;
--4.2 WEB_PASSWORD2
update Apex_2020.Wwv_Flow_Fnd_User set WEB_PASSWORD2 = ’*******粘贴的密码***‘ WHERE User_Name = 'ADMIN' ;