ORA-01410: invalid ROWID

create table tq84_A (val number);
create table tq84_B (val number);

insert into tq84_A values (1);
insert into tq84_A values (2);

select * from tq84_B where rowid = (select rowid from tq84_A where val = 1);

drop table tq84_A;
drop table tq84_B;