tag:blogger.com,1999:blog-1561253375800464394.post3953843086951087505..comments2024-03-13T11:59:19.468+01:00Comments on Denes Kubicek ApEx BLOG: Using Oracle Text with Table DataDenes Kubicekhttp://www.blogger.com/profile/01962373591521960882noreply@blogger.comBlogger27125tag:blogger.com,1999:blog-1561253375800464394.post-22936173960036372842017-01-20T13:21:16.209+01:002017-01-20T13:21:16.209+01:00try rebuilding the indextry rebuilding the indexDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-47117348941714049162017-01-14T21:18:19.685+01:002017-01-14T21:18:19.685+01:00This is great. I followed your instructions and it...This is great. I followed your instructions and it worked beautifully. When my search term is more than one word, it doesn't work. Do you know how i can fix that?<br />thank youabulfeeedhttps://www.blogger.com/profile/08942577530998809965noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-41327712115341111432010-03-25T22:21:01.106+01:002010-03-25T22:21:01.106+01:00O.K. thanks for checking. So only .docx and .xlsx ...O.K. thanks for checking. So only .docx and .xlsx are not indexed?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-52929083199034261562010-03-25T19:02:57.313+01:002010-03-25T19:02:57.313+01:00- Document generated by Office Word 2007 with exte...- Document generated by Office Word 2007 with extension .docx are not indexed.<br /><br />- Document generated by Office Word 2003 if they are indexed.<br /><br />- Document generated by Office Excel 2003 with extension .xls if they are indexed but not displayed for ctx_doc.snippet.<br /><br />Document generated by Office Excel 2007 with extension .xlsx are not indexed.Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-6862905815070459102010-03-25T16:59:23.198+01:002010-03-25T16:59:23.198+01:00Does it index .doc files or .xls?
Denes KubicekDoes it index .doc files or .xls?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-11925821350528098142010-03-25T16:58:29.982+01:002010-03-25T16:58:29.982+01:00Yes!
that part is it works:
...FILTER TXSYS.AUTO_F...Yes!<br />that part is it works:<br />...FILTER TXSYS.AUTO_FILTER...<br /><br /><br /><br />but the documents .docx not indexedUnknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-22518732098590856772010-03-25T16:51:51.200+01:002010-03-25T16:51:51.200+01:00My question was:
Was it this part:
"I have ...My question was:<br /><br />Was it this part:<br /><br />"I have found that, although it should not make a difference, sometimes it helps to explicitly declare the filter in your parameters when creating the index:"<br /><br />?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-14314584256089431602010-03-25T16:46:18.807+01:002010-03-25T16:46:18.807+01:00as you say?as you say?Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-3280450471521155862010-03-25T16:35:46.022+01:002010-03-25T16:35:46.022+01:00O.K. What worked?
Denes KubicekO.K. What worked?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-32872353137703848732010-03-25T16:33:53.122+01:002010-03-25T16:33:53.122+01:00is wonderful! It worked for. Pdf but not for. Docx...is wonderful! It worked for. Pdf but not for. Docx<br />Anyway it's great. Thank you very much!!Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-52602742184706578202010-03-25T16:01:01.813+01:002010-03-25T16:01:01.813+01:00I had the same problem with 11g and I asked for a ...I had the same problem with 11g and I asked for a solution here:<br /><br />http://forums.oracle.com/forums/message.jspa?messageID=4044126#4044126<br /><br />Never had a chance to try the tips. You may give it a shot.<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-72928334670192960732010-03-25T15:42:31.408+01:002010-03-25T15:42:31.408+01:00Yes, Oracle 11g.Yes, Oracle 11g.Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-4452135121864076542010-03-25T15:23:22.362+01:002010-03-25T15:23:22.362+01:00Are you using 11g database?
Denes KubicekAre you using 11g database?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-41603373539263015862010-03-25T15:21:04.438+01:002010-03-25T15:21:04.438+01:00Hi, Denes!
There are problems with indexing versio...Hi, Denes!<br />There are problems with indexing versions .pdf or .docx ??Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-36807475024316128272010-03-25T12:36:42.589+01:002010-03-25T12:36:42.589+01:00Denes thanks is what I needed!
I will try and tell...Denes thanks is what I needed!<br />I will try and tell you!!Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-39999750162416478772010-03-23T21:04:40.714+01:002010-03-23T21:04:40.714+01:00O.K. now I understand. See this example:
http://a...O.K. now I understand. See this example:<br /><br />http://apex.oracle.com/pls/otn/f?p=31517:76<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-47314714250223795672010-03-23T21:02:27.848+01:002010-03-23T21:02:27.848+01:00as index a blob field?
examples: .pdf, .docx, .tx...as index a blob field?<br /><br />examples: .pdf, .docx, .txt...<br />I need to seek within contentUnknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-3798175327087434592010-03-23T20:46:11.766+01:002010-03-23T20:46:11.766+01:00I don't understand what you are asking.
Denes...I don't understand what you are asking.<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-25283511571555325072010-03-23T20:32:56.048+01:002010-03-23T20:32:56.048+01:00It can index a blob field or should I do different...It can index a blob field or should I do differently?<br /><br />Because I did it like you explain but just wanted varchar fields and not by the content of the blob field<br /><br />which is my fault?Unknownhttps://www.blogger.com/profile/06328083093172466290noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-55823598342394401772009-10-08T14:03:35.118+02:002009-10-08T14:03:35.118+02:00The demo works now. Someone must have deleted the ...The demo works now. Someone must have deleted the indexes. Highlighting is standard apex highlighting.<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-78365501177494084902009-10-08T13:42:32.080+02:002009-10-08T13:42:32.080+02:00Hi,
The demo doen't work now. Also, you haven...Hi,<br /><br />The demo doen't work now. Also, you haven't mentioned how the search text is highlighted? Could you please explain that?<br /><br />Thanks,Sruthinoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-32069808275927468102009-08-13T16:04:14.200+02:002009-08-13T16:04:14.200+02:00Hello
Now have successfully granted.
Now in my Ent...Hello<br />Now have successfully granted.<br />Now in my Enterprise Manager of Oracle 9i I can view object of my schema scott as<br />GRANTED<br />Priviliege | Schema | Object <br />EXECUTE | CTXSYS | CTX_DDL<br /><br />But facing the same problem of that erroe have earlier posted to you.<br />Please help if you can,<br />Thanks and Best RegardsSaimanoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-5766500249475179692009-08-12T19:54:54.687+02:002009-08-12T19:54:54.687+02:00Really thanks for your urgent Reply!
Yes have trie...Really thanks for your urgent Reply!<br />Yes have tried... and got thir error message<br /><br />ORA-04042: Procedure,function,package,or package body does not exist<br /><br /><br />Again thanks and Regrads...Saimanoreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-8042016662636783312009-08-12T16:59:30.064+02:002009-08-12T16:59:30.064+02:00The step by step explanation says:
"GRANT EX...The step by step explanation says:<br /><br />"GRANT EXECUTE ON ctx_ddl TO schema_name;"<br /><br />Have you done that part?<br /><br />Denes KubicekDenes Kubicekhttps://www.blogger.com/profile/01962373591521960882noreply@blogger.comtag:blogger.com,1999:blog-1561253375800464394.post-12227579508561049852009-08-12T16:48:42.353+02:002009-08-12T16:48:42.353+02:00Hello There...
I am using Oracle 9i and logged in ...Hello There...<br />I am using Oracle 9i and logged in by SCOTT schema is EMP, I've used your code script as it is.. but got this error message<br /><br />ORA-20000 :Oracle Text Error<br />DRG-12607: Only CTXSYS can create Multi-Column preferences<br /><br /> Is your script is complete?? Please need further help.ThanksSaimanoreply@blogger.com