Hello,
I am using Oracle 19, and have empty result when query all-objects based on the rowid.
Here is the query:
select * from all_objects where object_id = dbms_rowid.rowid_objects('rowidfromtable');
I got the "rowidfromtable" from via "select rowid from schema1.table1".
It should be not a permission issue, the 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!