Re: Row ID

ROWID identifies the place where Oracle has stored the row. Anything that causes rows
to be relocated makes an old ROWID Obsolete.

If you have the "Oracle Concepts" manual (two volumes in the doc set), look up
ROWID in there. You'll see a good treatment of when to avoid using ROWIDs, which is basically almost all the time.

If you want to pin your records, go back to IMS or IDMS. Relational isn't for you.

Fraser Boswell wrote in message <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 Sat Sep 04 1999 - 00:00:00 CEST