Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> iMT indexing

iMT indexing

From: Bill Tantzen <>
Date: Thu, 20 Sep 2001 07:04:46 -0700
Message-ID: <>


I'm just getting started with interMedia Text, and I have a question about indexing. I have a table with an id column as a primary key, and a second column which holds xml-tagged text. I understand how to create an index which allows me to to CONTAINS...WITHIN style searches on discrete zone sections, but I would like to do more complicated searches, using various combinations of tagged fields.

For instance, let's say I have a <title> field, and a <description> field. I want to search on each of these fields, so I have statements like so:

ctx_ddl.add_zone_section ( 'book_grp', 'description', 'description' ); ctx_ddl.add_zone_section ( 'book_grp', 'title', 'title' );

But say, for example, that I want to do a keyword search on a number of different fields. If I try to add something like:

ctx_ddl.add_zone_section ( 'book_grp', 'keyword', '...whatever...' );
ctx_ddl.add_zone_section ( 'book_grp', 'keyword', 'description' );
ctx_ddl.add_zone_section ( 'book_grp', 'keyword', 'title'   );

I receive the following error:

ORA-20000: interMedia Text error:
DRG-12206: tag description already exists in section group BOOK_GRP
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.CTX_DDL", line 221

Now, in the documentation I have read, I have seen statements such as "Tags are unique across the sections of a section group" which indicates that I can't do what I would like to do, but I have also seen statements such as "ZONE sections can enclose other sections, including themselves, and can be enclosed by other sections" which does sound like what I would like to do...

Hence, I'm confused. There don't seem to be any good examples around that take you beyond the most basic.

Any suggestions on how I might be able to create an index as described above? Or if you can point me to a good print or web resource, that would also be much appreciated!

Thanks in advance!


Please see the official ORACLE-L FAQ:

Author: Bill Tantzen

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: (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). Received on Thu Sep 20 2001 - 09:04:46 CDT

Original text of this message