RE: Oracle Text (ConText/InterMedia) and realtime updates

From: Jesse, Rich <Rich.Jesse_at_qtiworld.com>
Date: Tue, 13 Nov 2001 13:19:04 -0800
Message-ID: <F001.003C3DBD.20011113130542@fatcity.com>

Yeah, I thought about that, but according to Oracle, "ctxsrv" is desupported and will be removed "in a future version". I guess I'm hoping for something in the DB, too, instead of relying on an external program that needs the CTXSYS password hardcoded.

Thx!

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

----Original Message-----
Sent: Tuesday, November 13, 2001 14:23
To: Multiple recipients of list ORACLE-L

There is a server process that can run in the background to do this. Check out ctxsrv

hth
connor

• "Jesse, Rich" <Rich.Jesse_at_qtiworld.com> wrote: > Hey all,
  >
  > So, there we are, testing out InterMedia in 8i, in
  > the hopes of using Oracle
  > Text in 9i. Is there a way to automagically update
  > the context index
  > real-time? I tried a call to CTX_DDL.SYNC_INDEX in
  > a trigger body, but of
  > course the wrapped procedure does a COMMIT.
  >
  > The idea right now is to sync the index every minute
  > via DBMS_JOB, but that
  > just seems too hokey to me. Apparently, under
  > ConText in Oracle7, the
  > INT_RX procedure could be used in a trigger, but
  > it's been desupported.
  > (I'm guessing that locking was an issue?)
  >
  > Anyone have any ideas?
  >
  > TIA!
  > Rich Jesse System/Database
  -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.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 Tue Nov 13 2001 - 15:19:04 CST