Re: object id -> object name

select object_name from dba_objects where object_id=xxxx;

But you might be in for a surprise. The object id that appears in v$lock has a nasty habit of turning out to be the rollback segment being used for the locking transaction, from painful memory. If you want to identify the real table involved, you have to use the number contained in the ID1 column from v$lock, for the row that is holding the TM lock type.

Hopefully you knew that anyway, in which case apologies for stating the bleedin' obvious.

Regards
HJR

--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================


"Y" <y_at_y.y> wrote in message news:3C84408D.431E74B9_at_y.y...


> Hi,

> How to get the object name from object id?

> For example, I got the table id from lock view. I need to know the name

> of this table. How to know this information?

> Thanks for any help!

>

>