Re: object id -> object name

Thank you, Howard! You help me again!

I will try this tomorrow.

I got a lot of questions for Oracle. I'd like to ask you some of these.

1. "Oracle release all locks acquired by the statements within a transation when you either commit or rollback the transaction." Does that means Oracle didn't support "declare cursor ... with hold". (some application need their cursor keep open even after the ending of transaction.) ?
2. Does Oracle support "pre-fetch" or "pre-read"?

Best Regards,

"Howard J. Rogers" wrote:

> 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!
> >
> >
Received on Mon Mar 04 2002 - 22:39:59 CST