Home » Server Options » Text & interMedia » Synchronization of context index (Oracle 10g
Synchronization of context index [message #431704] Thu, 19 November 2009 03:52 Go to next message
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,
Re: Synchronization of context index [message #433017 is a reply to message #431704] Sat, 28 November 2009 19:31 Go to previous message
Messages: 2794
Registered: April 2006
Senior Member
SYNC_INDEX will run synchronously and will not impede any DML on the table.
Previous Topic: Oracle Text with INPATH
Next Topic: .tif Format to .Img format
Goto Forum:

Current Time: Sat May 27 07:07:47 CDT 2017

Total time taken to generate the page: 0.08940 seconds