Need Tablename for given Rowid

[Bimalaggarwal]

I have a rowid.
I want to know the table name which has its record belonging to this rowid.
I do not wish to go over ALL_TABLES and run full table scans for each table to find a matching rowid.

Is there a fast and simple way to do this ?

 

[karluk]

You can do this with the dbms_rowid package:

select owner, object_name from all_objects
where object_id = dbms_rowid.rowid_object('your rowid here');