| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Union Views on InterMedia Indexed Tables
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jack C. Applewhite
INET: japplewhite_at_inetprofit.com
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: ListGuru_at_fatcity.com (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). Received on Wed Feb 28 2001 - 17:41:09 CST
 |
 |