Urgent Intermedia Upgrade Problem!!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Urgent Intermedia Upgrade Problem!!!

  1. #1
    Join Date
    Aug 2002
    Posts
    24

    Unhappy Urgent Intermedia Upgrade Problem!!!

    We have just upgraded a development database from Oracle 8.1.6 to Oracle 8.1.7.0. 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?

    Thanks,
    Dave Peacock
    Oracle DBA
    Leeds, England

  2. #2
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    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

  3. #3
    Join Date
    Dec 2002
    Posts
    3
    rebulid the index with both the option optimize and i forget second but definatly both the two

  4. #4
    Join Date
    Aug 2002
    Posts
    24

    Intermedia

    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?
    Dave Peacock
    Oracle DBA
    Leeds, England

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width