Really?
Do you know which version?
In 8i it seems to be alive and well, and iFS requires it.
Maybe as of 9i?
Jared
"MacGregor,
Ian A." To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
ford.EDU> Subject: RE: Little OT: CLOB, Oracle
Text, and ADO
Sent by:
[EMAIL PROTECTED]
om
12/21/01 10:00
AM
Please respond
to ORACLE-L
Ctxserv has been deprecated. Check the directory
$ORACLE_HOME/ctx/sample/script for the approved ways of keeping the indexes
in synch.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-----Original Message-----
Sent: Friday, December 21, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
My experience with intermedia or context server, or whatever
they call it this week, is in dealing with iFS, so I know just
enough to be dangerous. :)
It sounds like you need to have the context server running
to periodically update the indexes.
On unix it's 'ctxsrv'. I suggest you read the docs on this
and do a search on metalink, there is some helpful
information there.
HTH
Jared
"Witold Iwaniec"
<wiwaniec@novali To: Multiple recipients of
list ORACLE-L <[EMAIL PROTECTED]>
stech.com> cc:
Sent by: Subject: Little OT: CLOB,
Oracle Text, and ADO
[EMAIL PROTECTED]
12/21/01 07:15
AM
Please respond
to ORACLE-L
Hello
It may be little OT but I am sure there are developers here. Also I
hope some DBAs may know the answer...
I am experimenting with Oracle Text - need to use the field from a
VB application.
I have a table with a CLOB column and a ctxcat index built on that
column. If I insert records using SQL Plus, TOAD, or similar tool,
the index is automatically updated so my query:
select note_oid from lrmi_note
where catsearch(note_data, 'SomeValue', null) > 0;
returns records matching the condition.
In the application - if I use ADODB.Connection with parameters and
execute my insert, the data is written, index automatically updated,
and my query returns matching records.
But if I use ADODB.Recordset to write the record, the data is written
but the index doesn't get updated. If I open SQL Plus and run:
select * from lrmi_note where note_oid = my_new_oid;
it shows me the record with the CLOB column filled. But if I query
the CLOB column using catsearch(), it doesn't return the record. If I
rebuild the index, the query with catsearch() will return the records.
But one of the reasons to use ctxcat indes is that it is updated with
each transaction...
While it may be specific to ADO I wonder if some Oracle gurus
know, or can direct to some info, why Oracle doesn't update the
ctxcat index even though the record is written and apears correctly.
Witold==================================
Witold Iwaniec
Sr Software Developer
NovaLIS Technologies
[EMAIL PROTECTED]
http://www.novalistech.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Witold Iwaniec
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
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).
