Re: Row ID

Fraser Boswell wrote:

> 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

No, it won't be valid. Using a rowid to track records is not a good idea at all. rowid's are never inherited and if you kept a record of them in another table you'd have to ensure that if you delete from the original table then you'd need to delete from the other table as well. Using rowids to track anything would be akin to keeping a list of stack pointer values throughout the life of a program and then having the next run of the program fail if the stack pointer values are different. Received on Wed Sep 01 1999 - 00:00:00 CEST