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
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