Re: Intermedia indexing

Here are the answers to your questions (hope they are complete and helpful):

1. This in normal behavior when a changed record drops out of the index - interMedia needs to reindex it because extent of changes are not known: it may be one word change or a different document put in place of old. So a trigger on indexed table marks the changed row as pending indexing and interMedia excludes it from search until it is reindexed. See below on ways to deal with this behavior.
2. rebuilding index with 'sync' actually indexes just these 'dropped out' or new records (that is, all pending), while without sync the whole index will be rebuilt (taking a lot more time and resources usually).
3. Yes. You can select from CTX_USER_PENDING view to see all records that are to be [re-]indexed. To find out which indexes are to be synchronized (ctx_ddl.sync_index('index name') or alter index index_name rebuild parameters('sync')) use this query:

select distinct pnd_index_name from ctx_user_pending

To synchronize all indexes in the schema, use this pl/sql:

for p in (select distinct pnd_index_name from ctx_user_pending) loop  execute immediate 'alter index '||

             p.pnd_index_name||' rebuild online parameters(''sync'')';

• the following call has the same effect
• ctx_ddl.sync_index(p.pnd_index_name); end loop;

Depending on amount of altered and/or new records this script may take a while, but indexes will be available during its execution.

You may also start context server (ctxsrv) which will poll pending indexes for each user at regular intervals and reindex changed/new records in background. Read the documentation on how to start ctxsrv.

4) Can't tell for sure, but this is probably possible, although with a lot of effort - you will have to extract all new interMedia Text files, put them in correct locations replacing old ones and then run sql scripts that will reinstall the database portion of the tool. Also note that new version of interMedia Text probably has some hooks with Oracle internals which may not be there in older version. So if you want your interMedia Text to be up to date, you better upgrade to 8.1.7 and then patch to 8.1.7.2. Besides, 8.1.6 is already desupported.

hth.

--
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.


"S P Arif Sahari Wibowo" <arifsaha_at_yahoo.com> wrote in message
news:Pine.LNX.4.33.0110171358220.13081-100000_at_macbeth.tirone.com...


> Hi!

>

> Do you know something about intermedia indexing on 8.1.6?

> I have several question to ask:

>

> - Apparently when the intermedia indexed field of a record changed, the

> record will be taken out of the intermedia index. The same search that

> found the record before, cannot found it anymore. Is there any way to

> 'turn off' this behaviour. Since most editing is small, it is better to

> have the record on the old index than not at all.

>

> - What is the difference between rebuilding index with 'sync' option and

> without?

>

> - Is there anyway to find out if a specific index need to be rebuild (a

> record have the field changed)?

>

> - I use Oracle 8.1.6 on Linux, which didn't came with Inso filter. The

> later version came with it, though. Can I just install the install the

> Inso filter without reinstalling Oracle? How?

>

> Thank you.

>

> --

>                                    S P Arif Sahari Wibowo

>   _____  _____  _____  _____

>  /____  /____/ /____/ /____          arifsaha_at_yahoo.com

> _____/ /      /    / _____/       http://www.arifsaha.com/

>