Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_ROWID equivalent for Oracle 7??

Re: DBMS_ROWID equivalent for Oracle 7??

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Fri, 8 Sep 2000 07:53:15 +0100
Message-ID: <2pGPoKAbzIu5EwIe@ahardy.demon.co.uk>

In article <968387863.6317.4.pluto.d4ee154e_at_news.demon.nl>, Sybrand Bakker <postbus_at_sybrandb.demon.nl> writes
>There is none as the v7 rowid is composed of that info (except for the
>objectid)
>

Oops! Yes, you are quite right!

Andy
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>"Andy Hardy" <aph_at_ahardy.demon.co.uk> wrote in message
>news:3xfP+gA+4Au5EwpE_at_ahardy.demon.co.uk...
>> Hi,
>>
>> I'm want to find a row/rowid from an object_id, file number, block
>> number and row number (I'm looking at locked rows through v$session and
>> v$lock).
>>
>> Oracle 8 has the dbms_rowid facility to do this, what is the Oracle 7
>> equivalent?
>>
>> Andy
>> --
>> Andy Hardy. PGP ID: 0xA62A4849
>> ===============================================================
>
>
 

-- 
Andy Hardy. PGP ID: 0xA62A4849
===============================================================
Received on Fri Sep 08 2000 - 01:53:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US