Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query all-objects from rowid returns empty

mail8mzNov 23 2021 — edited Nov 23 2021

Hello,
I am using Oracle 19, and have empty result when query all-objects based on the rowid.

"
create table schem1.tb_test (id number(3), nm varchar2(20) );
insert into schema1.tb_test values (1, 'first nm');
commit;
select * from all_objects where object_id =
(select dbms_rowid.rowid_object(rowid) from schema1.tb_test where id =1);
"
It should be not a permission issue, the last query returns the table name for most tables under the same schema. However, i have no idea why the query returns empty for only several tables.
Thanks in advance!

This post has been answered by mail8mz on Nov 23 2021
Jump to Answer

Comments

Post Details

Added on Nov 23 2021
2 comments
127 views