Home » Server Options » Text & interMedia » Synchronization of context index (Oracle 10g 10.1.0.4)
Synchronization of context index [message #431704] Thu, 19 November 2009 03:52 Go to next message
k_mitra100
Messages: 28
Registered: October 2007
Location: Kolkata
Junior Member
Hallo everyone,

I have some questions regarding synchronization of context index. Can any one please help me?

1) Is the command ctx_ddl.sync_index is working as synchronously or asynchronously? I am executing this command from a plsql procedure. The procedure takes around 20 seconds to run. Does it mean that the command ctx_ddl.sync_index is executed by this time or is that command working asynchronously in the background?


2) Can any DML statement be executed on the main table (where data is stored from used end) at the time of synchronization through the command ctx_ddl.sync_index?


Thanks in advance,
Kaushik.

Report message to a moderator

Re: Synchronization of context index [message #433017 is a reply to message #431704] Sat, 28 November 2009 19:31 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
SYNC_INDEX will run synchronously and will not impede any DML on the table.

Report message to a moderator

Previous Topic: Oracle Text with INPATH
Next Topic: .tif Format to .Img format
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Feb 06 23:41:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.