Re: doubt in INDEX

Creat index will not change rowids. Rowids are not easily changeable. Here are the evil ways of changing rowids:

1. alter table move ......
2. Update moves the row from one partition to another.
3. Update of the cluster key moves the row from one cluster block to another.
4. Update of the primary key in an IOT (there are complications with IOT, so people should generally use urowid. If you are enableing constraints, you should generally use $ORACLE_HOME/rdbms/admin/utlexpt1.sql to create the exceptions table, so tthat EXCEPTIONS table is created with urowid)
5. export/truncate/import

Creating index does not change rowid.

On 2002.09.02 00:13 guess who wrote:
> 1.)
> People are saying that if a table is indexed then the all the
> rowids will be changed , whether it is true....If so , then how it
> is done , give example please.....
>
> 2.)What are all the ways for the rowids to be changed....
>
> Explain.....
>
> Regards,
> Prakash.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: guess who
> INET: yours_in_at_rediffmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Mladen Gogala
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).