OraFAQ Forum: Text & interMedia

Home » Server Options » Text & interMedia » InterMedia Index

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

InterMedia Index [message #120787]

Mon, 23 May 2005 14:54

Duane
Messages: 581
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.

Report message to a moderator

Re: InterMedia Index [message #120789 is a reply to message #120787]

Mon, 23 May 2005 15:03

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.).

Report message to a moderator

Re: InterMedia Index [message #120791 is a reply to message #120789]

Mon, 23 May 2005 15:14

Duane
Messages: 581
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.

Report message to a moderator

Re: InterMedia Index [message #120798 is a reply to message #120791]

Mon, 23 May 2005 15:59

Barbara Boehmer
Messages: 9104
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.

Report message to a moderator

Re: InterMedia Index [message #120799 is a reply to message #120787]

Mon, 23 May 2005 16:05

Duane
Messages: 581
Registered: December 2002

Senior Member

Doh! That was it, thanks Barbara.

Report message to a moderator

Previous Topic:	Problem with LOB Deallocation
Next Topic:	Can Ultra Search be used to only validate links?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 18:58:24 CST 2025