Re: Row ID

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 - 00:00:00 CEST