From tantz001@tc.umn.edu Thu, 20 Sep 2001 07:04:46 -0700 From: "Bill Tantzen" Date: Thu, 20 Sep 2001 07:04:46 -0700 Subject: iMT indexing Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi! 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 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! Bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Tantzen INET: tantz001@tc.umn.edu 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).