Message-Id: <10589.114532@fatcity.com> From: Linda Hagedorn Date: Mon, 14 Aug 2000 12:29:32 -0700 Subject: RE: Index creation and locking Hi Lisa! Thanks for the note. I ran the create index and no one complained. I may have been lucky. :) Oracle 8.0.5.2.1 was the release. Regards, Linda -----Original Message----- From: Koivu, Lisa [mailto:lkoivu@qode.com] Sent: Monday, August 14, 2000 6:00 AM To: Multiple recipients of list ORACLE-L Subject: RE: Index creation and locking Linda, I have seen this happen with 'resource busy and acquired with nowait specified' error returned to a user trying to query a table while (bitmap) index creation is running. However, it was not consistent. Heck, try it out and see what you end up with. Let us know. Lisa -----Original Message----- From: Linda Hagedorn [ mailto:Linda@pets.com ] Sent: Friday, August 11, 2000 8:47 PM To: Multiple recipients of list ORACLE-L Subject: Index creation and locking Does index creation lock the underlying records or table for the duration of the creation, and subsequently interfere with other transactions, such as on-line? -- Author: Linda Hagedorn INET: Linda@pets.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@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).