Home » Server Options » Text & interMedia » InterMedia Index
InterMedia Index [message #120787] Mon, 23 May 2005 14:54 Go to next message
Duane
Messages: 557
Registered: December 2002
Senior Member
I'm trying to create and use an InterMedia index but I receive the error "ORA-29833: indextype does not exist". I take it I must create the indextype using a "CREATE INDEXTYPE" statement. If so, what do I use in the "FOR" parameter of the statement or what should the SQL statement look like?

I'm running 9iR1 if that helps. Also, I find it odd that you have to create the indextype and that it's not a pre-defined index in 9i.
Re: InterMedia Index [message #120789 is a reply to message #120787] Mon, 23 May 2005 15:03 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Duane, are you asking about an index on a text column? Is so, this would be called Oracle Text in 9i and up. interMedia now deals with with multimedia (audio, video, etc.).
Re: InterMedia Index [message #120791 is a reply to message #120789] Mon, 23 May 2005 15:14 Go to previous messageGo to next message
Duane
Messages: 557
Registered: December 2002
Senior Member
Todd,

Yes, an index on a text column using InterMedia Text. I'm using the examples in the book, Expert One-on-One (Tom Kyte), Chapter 17 for setting it up.

create index mytext_idx
on mytext (thetext)
indextype is CTXSYS.CONTENT

I receive an error as mentioned above.
Re: InterMedia Index [message #120798 is a reply to message #120791] Mon, 23 May 2005 15:59 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
conteXt with an X, not conteNt with an N:

scott@ORA92> create table mytext
  2    (id	number primary key,
  3  	thetext varchar2(4000))
  4  /

Table created.

scott@ORA92> create index mytext_idx
  2  on mytext (thetext)
  3  indextype is CTXSYS.CONTENT -- wrong
  4  /
indextype is CTXSYS.CONTENT -- wrong
                    *
ERROR at line 3:
ORA-29833: indextype does not exist


scott@ORA92> create index mytext_idx
  2  on mytext (thetext)
  3  indextype is CTXSYS.CONTEXT -- right
  4  /

Index created.

Re: InterMedia Index [message #120799 is a reply to message #120787] Mon, 23 May 2005 16:05 Go to previous message
Duane
Messages: 557
Registered: December 2002
Senior Member
Doh! That was it, thanks Barbara.
Previous Topic: Problem with LOB Deallocation
Next Topic: Can Ultra Search be used to only validate links?
Goto Forum:
  


Current Time: Thu Mar 28 08:01:08 CDT 2024