I've discovered a workaround for an Oracle InterMedia Text error. Our platform: Oracle 8.1.6 on Windows2000 Our problem: We get the following errors when querying (with a Contains() expression) a Union All View of identically-structured tables, each with an InterMedia index on the same CLOB column: ORA-20000: interMedia Text error: DRG-10599: column is not indexed Each table can be successfully queried alone or within a Union All Select - just not when referenced in a view. The solution is to create a Select * From <Table> View on each individual table, then use those individual views in the Union All view. Bizarre, eh? Yes, but it works. It does not solve the problem of getting the same error messages as above when using the Score() function in a query that references the Union All view. This is a problem for us on both 8.1.6 and 8.1.7. BTW, 8.1.7 doesn't exhibit the above-mentioned problem that we experience on 8.1.6. 8.1.7 just gives the error when you use the Score() function. Hope this helps someone. Jack -------------------------------- Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
