update sys.obj$ set OWNER# = (select user_id from dba_users where username = 'junk123') where OWNER# = (select user_id from dba_users where username = 'junk');


I would be interested if the above sql works, I'm not brave enough to try it myself. (best do a backup 1st me thinks)