Message-Id: <10711.124703@fatcity.com> From: "Koivu, Lisa" Date: Fri, 15 Dec 2000 09:27:02 -0500 Subject: IMT indexes question This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C066A3.17B943B6 Content-Type: text/plain; charset="iso-8859-1" good morning all - Does anyone know how to circumvent the Oracle restriction of having only one intermedia text index on a column? I have to arrange a rebuild of our largest index because it got hung up in LOADING state. I'd like to be able to create a second index to be available when I drop the first one, but it won't let me create a second index. Any suggestions? Happy Friday everyone! Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." ------_=_NextPart_001_01C066A3.17B943B6 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable IMT indexes question

good morning all -

Does anyone know how to circumvent the = Oracle restriction of having only one intermedia text index on a = column?  I have to arrange a rebuild of our largest index because = it got hung up in LOADING state.  I'd like to be able to create a = second index to be available when I drop the first one, but it won't = let me create a second index. 

Any suggestions? 

Happy Friday everyone!

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  = 33319

V: 954.484.3191, x174
F: 954.484.2933
C: 954.658.5849
http://www.qode.com

"The = information contained herein does not express the opinion or position = of Qode.com and cannot be attributed to or made binding upon = Qode.com."