When does ROWID change ?

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Tue, 02 Nov 1999 10:44:59 GMT
Message-ID: <1103_941539499@prague_main>

Is it safe to use a ROWID as a key for some table?

I have a table that doesn't have any reasonable key (I'd have to use the "sum" of many keys as the key). Into another table I compute some data which should be tied to the rows in the first table. Many rows from Table2 to one in Table1, most rows in Table1 do not have anything in Table2.

I thought it's safe to tie the tables using Table1.ROWID as the key. I thought the ROWID would change only if I deleted and recreated the rows in Table1, or if I copied the data over to a different server. Is this assumption correct? Does "Analyze table" change the ROWIDs?

It seemed to work OK at first but I get some strange results now and want to make sure this is not the problem..

Thanks, Jenda (CC: would be appreciated) http://Jenda.Krynicky.cz Received on Tue Nov 02 1999 - 04:44:59 CST