Re: Identity columns in Oracle?

From: David P <davidp3_at_soho.ios.com>
Date: 1996/06/22
Message-ID: <31cb9dac.2816059_at_198.4.75.200>#1/1


On 21 Jun 1996 20:40:08 GMT, Peter Gurmann <pgurmann_at_via.at> wrote:

>
>btw, the pseudo column ROWID (phys addr of the row) may be something like
>a Identity column, but NEVER use it for referential integrity, after
>imp/exp ROWIDs change !
>
>good luck !
>
>Peter
>
ROWID changes not only imp/exp, but say you ALTER some COLUMN NUMBER(10) to COLUMN NUMBER(11) Oh boy , here goes clustered row with different ROWID but still ref by ROWID works so fast..
Dave Received on Sat Jun 22 1996 - 00:00:00 CEST

Original text of this message