时间:2021-07-01 10:21:17 帮助过:14人阅读
命令:select * from user$ t where t.name like ‘%newuser%‘;
取出user#的值,这里假设为108;
c.手动将用户名称##newuser修改为newuser;
命令:update user$ set name=‘newuser‘ where user#=108;
commit;
d.强制刷新
alter system checkpoint;
alter system flush shared_pool;
d.重新设置密码newuser
alter user newuser identified by newuser;