Creat index will not change rowids. Rowids are not easily changeable. Here are the evil ways of changing rowids:
a) alter table move ...... b) Update moves the row from one partition to another. c) Update of the cluster key moves the row from one cluster block to another. d) 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) e) 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
