|
|
Topic |
Replies |
Views |
Last message |
![This topic has been locked](/forum/theme/orafaq/images/readlocked.png) |
|
Announcement: Oracle Text provides easy Google-like searching using new query parser |
0 |
29928 |
Wed, 11 July 2012 12:46 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
delete from ctxsys.dr$delete - statement not using bind variables: how to contain of limit? |
0 |
16333 |
Tue, 10 October 2023 07:54 By: leon@ubeeo.nl ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to determine last tiime Content was indexed Oracle 19c ( 1 2) By: kjcook on Thu, 10 August 2023 |
47 |
29633 |
Thu, 17 August 2023 21:28 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Text Search - How to drop DR$ tables and indexes Oracle DB, 19.0.0.0.0, Windows 10 |
2 |
13551 |
Wed, 25 January 2023 03:55 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Materialized View with Context Index Oracle, 12.2, Unix By: Duane on Fri, 02 September 2022 |
2 |
21881 |
Mon, 16 January 2023 13:46 By: Duane ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Text Search - Handling special characters and blank search term Oracle DB v11.2 |
11 |
26327 |
Mon, 16 January 2023 11:49 By: OraDev16 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORACLE SQL POSSIBE BUG 11G |
5 |
50941 |
Tue, 19 May 2020 12:58 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ctxhx process and Oracle Text indexes DB 19.6 |
3 |
30058 |
Tue, 19 May 2020 10:45 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
19c Orace Text Index(CTXSYS.CONTEXT ) - String search anomaly Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
1 |
22369 |
Thu, 27 February 2020 09:52 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
pixel (rgb) values extraction function SQL*Plus: Release 10.2.0.3.0 |
0 |
21065 |
Mon, 25 November 2019 12:45 By: indra0721 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to ignore particular string or character in contains function oracle ,12c By: jgjeetu on Thu, 12 September 2019 |
2 |
24984 |
Thu, 12 September 2019 11:12 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Uncertainty while searching string which contains æøå characters Oracle,12c By: jgjeetu on Wed, 11 September 2019 |
1 |
22021 |
Thu, 12 September 2019 10:49 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Stoplists and Nickname lists Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: vka2b on Wed, 01 August 2018 |
12 |
58917 |
Wed, 19 September 2018 09:36 By: vka2b ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Text Performance Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: vka2b on Tue, 24 July 2018 |
18 |
55200 |
Wed, 12 September 2018 18:28 By: vka2b ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
How to escape reserved words returned in column values as parameters to CONTAINS function Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production By: vka2b on Wed, 27 June 2018 |
3 |
32240 |
Thu, 28 June 2018 18:01 By: vka2b ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Need to get the one specific record with 's oracle 11.2.0.4 By: mvrkr44 on Tue, 05 December 2017 |
4 |
31314 |
Thu, 07 December 2017 01:48 By: mvrkr44 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
where to check context index sync status oracle 12c By: mvrkr44 on Thu, 09 November 2017 |
2 |
35527 |
Sun, 12 November 2017 23:28 By: mvrkr44 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Matching query oracle 11g |
15 |
44110 |
Mon, 24 July 2017 00:06 By: mvrkr44 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Full Text Search & ifilter for .docx Oracle DB unspecified version |
0 |
20681 |
Mon, 20 March 2017 09:11 By: brianmaltass ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Search over multiple Columns and Tables possible? |
2 |
26476 |
Thu, 15 September 2016 01:44 By: GBuchner ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Create Index for CLOB-datatype Oracle Locator 11g By: moehre on Mon, 05 September 2016 |
2 |
26592 |
Mon, 05 September 2016 16:05 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Fulltext search Oracle 11g or Hive 0.14.0 |
2 |
26200 |
Wed, 03 August 2016 15:39 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
PDF to HTML convert using ctxsys.auto_filter different result db 11.2 and 12.1 Database 11.2.0.1.0 / 12.1.0.1.0 |
4 |
32252 |
Mon, 18 April 2016 13:37 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
contains query not returning expected results 11.2.0.2 , Redhat 2.6.18-194.el5 By: jxxx on Mon, 21 December 2015 |
0 |
20904 |
Mon, 21 December 2015 08:33 By: jxxx ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
matching names from two tables 10g |
2 |
24583 |
Tue, 24 November 2015 22:05 By: m.abdulhaq ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Text tuning Oracle,10GR2,Linux RHEL6 |
30 |
52367 |
Mon, 28 September 2015 00:31 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-29849 exception Oracle 11g R2 |
4 |
23114 |
Tue, 11 August 2015 00:34 By: sherlocksher ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Searching Synonyms Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production |
7 |
28782 |
Fri, 07 August 2015 13:12 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
which index is good ctxsys.context/ctxsys.CTXCAT |
9 |
29652 |
Thu, 23 July 2015 17:05 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
wild card search on CLOB not giving require result in 12C Oracle 12 C Standard edition |
7 |
26810 |
Thu, 11 June 2015 11:52 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Find subset of string Oracle 11g, Win 7 |
1 |
19783 |
Tue, 14 April 2015 20:36 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Abbreviations and acronyms thesaurus 11gR2 |
1 |
22062 |
Tue, 17 March 2015 20:36 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Accent insensitive indexation 12.1.0.2 |
2 |
21143 |
Sat, 07 March 2015 00:46 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Materialized view having oracle text index not returning results after complete refresh |
12 |
33260 |
Tue, 03 March 2015 14:22 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Index creation performance problem with LOB/CLOB content 11.2.0.4 PB12 Windows x64 By: ab-md on Sun, 01 February 2015 |
1 |
21251 |
Sun, 01 February 2015 16:14 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Text Search Performance issue with frequent words |
2 |
20900 |
Tue, 02 September 2014 15:27 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
like performance than CATSEARCH Performance incase of wild character |
1 |
19279 |
Tue, 12 August 2014 13:36 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
extract information from an unstructured email into tables RDBMS 11R2 |
12 |
31495 |
Thu, 07 August 2014 17:00 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Find Words in a String 11g Release 2 Windows By: Duane on Fri, 11 July 2014 |
32 |
46187 |
Fri, 25 July 2014 19:46 By: Barbara Boehmer ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Is there a way to customize the BASE_LETTER conversions that oracle text does Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production |
0 |
20604 |
Wed, 16 July 2014 12:55 By: orauser001 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |