Oracle Text Index

[Chris Seidel]

Hi,

when gets a text index type CONTEXT updated?
Like every other index on insert/update/delete or only when I call create
index?

Thank you

[Mark D Powell]

There is more than one kind of context index. There is one version
that Oracle can update as the table data changes though you usually
have to run a sync operation to perform the index update:
CTX_DDL.SYNC_INDEX.

See the Oracle® Text Reference 10g Release 2 (10.2) Part Number
B14218-01 or your version's equilivent.

HTH -- Mark D Powell --

[Tim Arnold]

"Chris Seidel" <cse...@arcor.de> wrote in message
news:48c13ae9$0$11084$9b4e...@newsspool1.arcor-online.net...

Tell us what version of Oracle and OS. Depending on the version there are a
variety of ways:
On commit, via a scheduled job, an OS service, etc.

[Chris Seidel]

Tim Arnold wrote:

> Tell us what version of Oracle and OS. Depending on the version there
> are a variety of ways:
> On commit, via a scheduled job, an OS service, etc.

Oracle 9i and higher
No special OS

[BicycleRepairman]

search for ctx_ddl.sync_index() in the Oracle Text Reference.
In 11g, you can set up the synchronization up within the Create Index
command.

[Chris Seidel]

BicycleRepairman wrote:

> search for ctx_ddl.sync_index() in the Oracle Text Reference.
> In 11g, you can set up the synchronization up within the Create Index
> command.

Thank you

[jeremy]

In article <84501520-0ef0-4fbb-9088-
d6cf19...@z72g2000hsb.googlegroups.com>, BicycleRepairman says...

> search for ctx_ddl.sync_index() in the Oracle Text Reference.
> In 11g, you can set up the synchronization up within the Create Index
> command.
>

As you can also in 10g.

--
jeremy