Re: interMedia indexing question

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 29 Jun 2001 12:23:33 +0100
Message-ID: <3b3c6543$0$8514$ed9e5944@reading.news.pipex.net>

This behaviour is as they say 'by design'. You need to periodically (or even after every insert yuk) rebuild the indices. you can accomplish this either by use of the deprecated ctxsrv as suggested by crappygolucky, or you can use the CTX_DDL package as the ctxsys user

for example

BEGIN
CTX_DDL.SYNC_INDEX();
END;
/

will update all intermedia indices. This is the current recommended approach from oracle,

--
Niall Litchfield
Oracle DBA
Audit Commission UK

"Todd Tran" <toddtran_at_nortelnetworks.com> wrote in message
news:3B3BA0CC.1EEB932C_at_nortelnetworks.com...


> I am using Oracle 8.1.7

>

> Todd Tran wrote:

>

> > Hi,

> >

> > I am having problem with interMedia search after creating intermedia

> > indexes. The problem I am seeing is that if I create the indexes after

> > my records have been added to the DB, then the intermedia search works

> > fine, I get the result I expected.  But if I add some new records after

> > the indexes were created, then the search fails to pick up the new

> > records.

> >

> > Anyone experience this problem and know the solution?

> >

> > Thanks,

> >

> > Todd

>

Received on Fri Jun 29 2001 - 06:23:33 CDT