Re: doubt in INDEX
Dear "Guess Who", I don't think so. BTW, who are the "people" and why do they think so, we would love to see their explanation/theory. There could be several possibilities for having the rowids changed, like Exporting and Importing the tables, Moving the tables to diff T.S etc. Other ideas are welcome ... HTH, Rajesh - Original Message - Date: Sun, 01 Sep 2002 20:13:21 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 1.) > People are saying that if a table is indexed then the all the > rowids will be changed , whether it is trueIf 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). > -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal 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).
Re: doubt in INDEX
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 trueIf 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).
RE: doubt in INDEX
Prakash, Though i don't remember fully, but the ROWID consists of the Block Address, DataFile and other info. Rowid's change when the row is migrated to a different location. Since creating index doesn't migrate the row, if the table is indexed the rowid's wont change. Naveen -Original Message- Sent: Monday, September 02, 2002 9:43 AM To: Multiple recipients of list ORACLE-L 1.) People are saying that if a table is indexed then the all the rowids will be changed , whether it is trueIf 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata 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).
