Re: Use/Dont Use ROWID in queries
Date: 1996/01/01
Message-ID: <4c9hq8$g91_at_dub-news-svc-5.compuserve.com>#1/1
In article <4bcivs$jr3_at_cloner2.ix.netcom.com>,
chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>> Sounds half right. It's true that imp/exp will change ROWIDs.
>> That's because they contain the exact address of the row
>> within the database (datafile#, block#, row#). So ROWIDs *will*
>> be unique in non-clustered tables.
A little off the subject, but can anyone tell me the internal packing format of the ROWID's? The oracle call interface mentions that the internal length of them is 6 characters, but to retrieve them I have to bind them to a structure that on VMS is 13 characters long.
Co-incidentally I have a need to store ROWID's using the least space possible, 6 chars would be perfect! Does anyone know the formula to pack and unpack these elements?
Ray Steel Received on Mon Jan 01 1996 - 00:00:00 CET