Home » Server Options » Text & interMedia » Intermedia vs Multilingual Data
Intermedia vs Multilingual Data [message #76046] Thu, 22 May 2003 13:26
Kiran G Kumar
Messages: 5
Registered: April 2003
Junior Member

In our oracle DB, we have a table which has a column, that keeps Multilingual Data (around

21 languages including Japanese, Chinese ..etc). Now we want to build a SEARCH feature in our web application, which will pick up the records from this table based on this field.

We want to use Oracle Text (formally Intermedia) features for this. I would to know what is the best way of using this, and what are all the things required to do to use this.

We have Oracle Intermedia feature is installed ( I mean I can create context indexes)

My questions are

(1) Which type of Index should be created on this column ? ( I heard that context index, catalog index and some other indexes.., so guide me which one is the best in my case)

(2) This field will ve updates/insert operations (I means users will insert new records/update existing record).. So, do these intermedia indexes will automatically updated

so that I can fetch these new records ? ( I mean if any updates/inserts happen in this field, by querying on this column will I get these records )

(3) Is there any maintainance activity required when we use this intermedia indexes ?

(4) Please let me know if there any pros and cons of using this intermedia ?

Appreciate your help.

Thanks for your time
Previous Topic: Oracle InterMedia Text
Next Topic: Coloumn is not index error in new schema
Goto Forum:

Current Time: Fri Sep 18 22:19:03 CDT 2020