Re: Will ROWID change during DB Runing??

By the way,
From the Oracle 7 Server, SQL Language Ref. Manual:

"For each row (record) in the database,
the ROWID pseudocolumn returns a row's address. ROWID values contain information necessary to locate a row:

• which data block in the data file
• which row in the data block ( first row is 0 )
• which data file ( first file is 1 )

Character values representing ROWIDs:

         block.row.file (3 hexadecimal strings)

For example:

         0000000F.0000.0002

is the 15th data block, the first row, of the 2nd file. A ROWID does not change during the lifetime of its row. However, you should not use ROWID as a table's primary key. If you delete and reinsert a row with the Import and Export utilities, for example, its ROWID may change. If you delete a row, ORACLE may reassign its ROWID to a new row inserted later.

Although you can use the ROWID pseudocolumn in the SELECT and WHERE clauses of a query, these pseudocolumn values are not actually stored in the database.
You cannot insert, update, or delete a value of the ROWID pseudocolumn."

"nntp.lucent.com" <grantzhou_at_gmail.com> wrote in message news:cr2rm9$kda_at_netnews.proxy.lucent.com...
> Hi,
>
> Does anyone know that whether the rowid will change for one record during
> ORACLE runing?
>
> From the below link
> http://www.adp-gmbh.ch/ora/concepts/rowid.html
> I found such words:
> Although a rowid uniquely identifies a row in a table, it might change its
> value if the underlying table is an index organized table or a partitioned
> table.
>
> Thanks in advance!
> Best Regards,
> Grant
>
>
Received on Fri Dec 31 2004 - 00:40:31 CST