Ora-20000 Oracle Text Error Drg-10849

here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Oracle text catsearch multiple in one predicate up vote 5 down vote favorite 2 I have a table with 2 column of type varchar2. I have create 2 indeces CREATE INDEX DOC_IDX_1 ON DOCUMENTO ( column1 ) INDEX TYPE IS CTXSYS.CTXCAT ; CREATE INDEX DOC_IDX_2 ON DOCUMENTO ( column2 ) INDEX TYPE IS CTXSYS.CTXCAT ; when I execute the query select * from table1 where CATSEARCH(column1, 'AAA', NULL) > 0 AND CATSEARCH(column2 , 'BBBb', NULL) > 0 I get the following error ORA-20000: Oracle Text error: DRG-10849: catsearch non supporta il richiamo funzionale DRG-10599: la colonna non è indicizzata 20000. 00000 - "%s" *Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated. *Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. The English translation is: $ oerr drg 10849 10849,0, "catsearch does not support functional invocation" // *Cause: the query plan for your query is invoking a catsearch operator // functionally rather than as an index rowsource. The catsearch // operator does not support functional invocation // *Action: add optimizer hints so that all catsearch operators are // performed through index scans // *Mnemonic: QE_CATSEARCH_FUNCINV // And 10599,0, "column is not indexed" // *Cause: The column specified is not indexed. // *Action: Create index on the column before performing this operation // *Mnemonic: DL_COLUMN_NOT_INDEXED How can I fix the problem? Thanks Sergio oracle text share|improve this question edited Jan 10 '14 at 12:30 Guido Leenders 2,0921828 asked Jan 5 '14 at 8:44 user3162140 264 Could you please translate the first three lines to simple English? –Rachcha Jan 6 '14 at 2:33 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Please refer to this known solution for the comment of Barba

Search Username Password Remember Me? Register Lost Password? facebook google twitter rss Free Web Developer Tools Advanced Search  Forum Databases Oracle Development Mixed queries with Oracle Text Thread: Mixed queries with Oracle Text Share This Thread  Tweet This + 1 this Post To Linkedin Subscribe to this Thread  Subscribe to This Thread February 18th, 2010,08:38 AM #1 No Profile Picture ziploc1010 View Profile View Forum Posts  Registered User Devshed Newbie (0 - 499 posts)  Join Date Feb 2010 Posts 8 Rep Power 0 Mixed queries with Oracle Text Hi, http://stackoverflow.com/questions/20931676/oracle-text-catsearch-multiple-in-one-predicate I am trying to perform a query that uses an Oracle Text domain index and a normal index. I have to perform this query on two different Oracle databases. The query works on one database, but it does not on the other. The two database names are m1_cl and ld_cl. When running the query on ld_cl, it is not allowing me to use filtering http://forums.devshed.com/oracle-development-96/mixed-queries-oracle-text-677563.html criteria on multiple columns when using an Oracle Text function. For ld_cl, the query does not allow me to index on any other filtering criteria, besides the domain index: select * from ld.staging where catsearch(msg,'117',null) > 0 and vin = '3GNEC-----6626' Error report: SQL Error: ORA-20000: Oracle Text error: DRG-10849: catsearch does not support functional invocation DRG-10599: column is not indexed 20000. 00000 - "%s" *Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated. *Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. If I run the same query on m1_cl, it does not give me this error: select * from ld.staging where catsearch(msg,'117',null) > 0 and vin = '3GNEC-----6626' I saw that the explain plan is different for each query. On ld_cl, it is: SELECT STATEMENT TABLE ACCESS STAGING BY GLOBAL INDEX ROWID Filter Predicates CTXSYS.CATSEARCH(MSG,'117',NULL)>0 INDEX IDX_STAGING_VIN RANGE SCAN Access Predicates VIN='3GNE------6626' On m1_cl, it is: SELECT STATEMENT TABLE ACCESS STAGING BY INDEX ROWID BITMAP CONVERSION BITMAP AND BITMAP CONVERSION INDEX VIN_IDX Access Predicates VIN='3GNEC-------6626' BITMAP CONVERSION SORT DOMAIN INDEX MSG_IDX Access Predi

CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a https://community.oracle.com/thread/2424038 blank message. Please type your message and try again. More discussions in PL/SQL and https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2460552453360 SQL All PlacesDatabaseDatabase Application DevelopmentPL/SQL and SQL This discussion is archived 2 Replies Latest reply on Aug 15, 2012 8:57 AM by nohup oracle text error when generating random rows nohup Aug 1, 2012 12:44 PM Hello firing SELECT * FROM ( SELECT NAME,EMAIL,ADDRESS1,ADDRESS2,CONTACT_NAME,MOBILE,TELEPHONE FROM MV_CAT_SEG_REG_PROD WHERE CATSEARCH(CAT_TYPES,'security services*' ,NULL)>0 AND PLAN_ID=1 AND ACT_STATUS='N' ORDER ora-20000 oracle BY DBMS_RANDOM.VALUE ) where rownum < 4; returns ORA-20000: Oracle Text error: DRG-10849: catsearch does not support functional invocation DRG-10599: column is not indexed 20000. 00000 - "%s" *Cause: The stored procedure 'raise_application_error' was called which causes this error to be generated. *Action: Correct the problem as described in the error message or contact the application administrator or DBA for more information. using oracle 10gr2 on windows server ora-20000 oracle text 2003 i have tried 1)dropping the index and creating it again, the index type is "CTXSYS"."CTXCAT" 2) deleting the stats -checking 3)recreating the stats- checking the table here is a materialized view i need to tell you people that there are two indexes cat_types_ind and cat_ids_idx on cat_types and cat_ids columns respectively the inner query uses cat_types_idx index when executed and seen in sqladvisor 1)removing the order by clause will make the query work but i really want that order by clause 2)the inner-query-only works fine 3) i have seen the forums and they have helped regarding the things i tried above but it does not work please tell me if i need to further elaborate on anything thanks in advance 109Views Tags: none (add) 10599Content tagged with 10599, 10849Content tagged with 10849, 11gContent tagged with 11g, 20000Content tagged with 20000, databaseContent tagged with database, drgContent tagged with drg, errorContent tagged with error, oraContent tagged with ora, oracleContent tagged with oracle This content has been marked as final. Show 2 replies 1. Re: oracle text error when generating random rows 953710 Aug 3, 2012 9:42 AM (in response to nohup) I have same problem, my query is: SELECT * FROM (SELECT /*+ FIRST_ROWS(50) */

15, 2010 - 9:05 am UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: Reflections from RMOUG Training Days 2015 (part 1) - enough with the shoulds, already!? Latest Followup You Asked Hi Tom, I have problem with intermedia search. I have a column which has char "#". I know that we have to remove this non alphanumeric character from stopwords list using ctx_ddl.set_attribute('Lexer Name','printjoins','#'). I have done this. After that when queriny like where contains(column_name ,'#') > 0 it returns many rows.No doubt that it filters most of the records but still there are many records which does not hold '#'. Then as per your suggestion last time with issue regarding "," I used query like where contains(column_name,'\#') > 0 but still the records werenot appropriate. On using an additional clause of instr(column_name,'#') >0 I am getting appropriate records. Can u please tell me what needs to be done. Tks sushil. and we said... Ahh, but do you have a row with "#" as an entire word??? You see, if you run "contains( cname, 'hello' ) > 0", that finds all rows that contain the word hello. Do you have a row with '#' as a word? If you do -- it'll work. If you do not -- contains isn't right for what you are doing -- instr is. ops$tkyte@ORA817DEV.US.ORACLE.COM> create table t ( data varchar2(50) ); Table created. ops$tkyte@ORA817DEV.US.ORACLE.COM> insert into t values ( 'How#Now#Red#Cow' ); 1 row created. ops$tkyte@ORA817DEV.US.ORACLE.COM> insert into t values ( 'How Now Red Cow' ); 1 row created. ops$tkyte@ORA817DEV.US.ORACLE.COM> insert into t values ( 'How # Now Red Cow' ); 1 row created. ops$tkyte@ORA817DEV.US.ORACLE.COM> exec ctx_ddl.drop_preference('my_lexer'); PL/SQL procedure successfully completed. ops$tkyte@ORA817DEV.US.ORACLE.COM> begin 2 ctx_ddl.create_preference('my_lexer','BASIC_LEXER'); 3 ctx_ddl.set_attribute('my_lexer','printjoins','#'); 4 end; 5 / PL/SQL procedure successfully completed. ops$tkyte@ORA817DEV.US.ORACLE.COM> create index t_ind_ctx on t(data) indextype 2 is ctxsys.context parameters('lexer my_lexer'); Index created. no here are all of the tokens we have parsed as "words" ops$tkyte@ORA817DEV.US.ORACLE.COM> select token_text from DR$T_IND_CTX$I; TOKE