Re: Row ID

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Wed, 01 Sep 1999 11:03:17 GMT
Message-ID: <VJ7z3.2475$E46.3200@news.rdc1.pa.home.com>

Yes.

Part of the row ID is the File number and the block number. Any movement of the row at all can make the rowid invalid.

Fraser Boswell <Fraser.Boswell_at_spamme.ed.ac.uk> wrote in message news:37CCF3C7.2945103D_at_spamme.ed.ac.uk...
> I'm recording the RowID of records in an Audit table (thanks Thomas Kyte
> for the advice), but was wondering what would destroy the RowID making
> it invalid. If all records in the table are copied to a new table, old
> table dropped and new table renamed back to the original, would the
> RowID be invalid for the new table?
> What else would cause the RowID to become out of step with the table?
>
> Thanks in advance
>
> Fraser
>
Received on Wed Sep 01 1999 - 06:03:17 CDT