Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Creating custom index on UCM tables ?

Reza.E-Oracle
Member Posts: 19 Employee
Hi Experts,
I know it is possible to add new information fields into UCM (DOCMETA table) through admin applet -> configuration manger.
My question is, Is it possible to create custom index on some of theses newly created fields?
something other than the "Enable for Search Index" checkbox.
Let's say you have added a custom field of type memo and want to create a text index on it so that
you can use search queries with <CONTAINS> or <IN>. (e.g. xCustomField <CONTAINS> 'something' )
at the moment without such a text index an attempt to use <CONTAINS> throws this error:
ORA-20000: Oracle Text error: DRG-10599: column is not indexed
I know it is possible to add new information fields into UCM (DOCMETA table) through admin applet -> configuration manger.
My question is, Is it possible to create custom index on some of theses newly created fields?
something other than the "Enable for Search Index" checkbox.
Let's say you have added a custom field of type memo and want to create a text index on it so that
you can use search queries with <CONTAINS> or <IN>. (e.g. xCustomField <CONTAINS> 'something' )
at the moment without such a text index an attempt to use <CONTAINS> throws this error:
ORA-20000: Oracle Text error: DRG-10599: column is not indexed
Answers
-
I don't know of a way through the UCM interface to do this, I've created indexes on columns in the database directly before. This has always worked well for me. Have you looked at the Zoned Fields under Administration in 10gR3 content server? I've not looked at it that much, maybe that's what it's doing? I think that is more related to the actual columns that get full text indexed and not really the index you are talking about though.
-
What version of content server are you using (7.5.1, 7.5.2, 10gR3) ?
What indexing engine are you currently using (Verity, Direct Database, Oracle Text Search)?
What database are you using (SQL 2000, SQL 2005, SQL 2008, Oracle, ect)?
This discussion has been closed.