Urgent Intermedia Upgrade Problem!!!
We have just upgraded a development database from Oracle 8.1.6 to Oracle 184.108.40.206. We use a content management system that uses Intermedia Text and this option has also been upgraded.
Following the upgrade the response time for free text searching has become unacceptably slow. It looks like the Intermedia indexes are not being used?
Does anyone have experience of upgrading Oracle dbs with Intermedia? Any suggestions or ideas would be appreciated?
When you issue CONTAINS statement, is it possible to get the result set without a text index on the column you specified?
How about rebuilding the indexes?
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
rebulid the index with both the option optimize and i forget second but definatly both the two
Thanks very much for the quick response. I've started rebuilding my indexes.
Have you already seen this after an upgrade or is this generally a good idea with interMedia text?
Why should the upgrade require the indexes to be rebuilt?
Click Here to Expand Forum to Full Width