SYNC INDEX runs forever [message #115707] |
Wed, 13 April 2005 15:06 |
hyarlagadda
Messages: 1 Registered: April 2005
|
Junior Member |
|
|
I have oracle IFS 1.1 version on UNIX.
There are already documents existing in IFS. I loaded 35,000 new documents into IFS.
I need to do a search on the contents of these files from another application. So I need to create text indexes before I do a content search.
Now when I try to run the following to sync up indexes for new documents.
begin
ctx_ddl.sync_index ( idx_name => 'ifs_text' );
end;
it is taking forever. Once it ran for more than 24 hours and still could not never complete it. I have around 320 GB of data in 1666775 documents.
What are the ways in which I can speedup text indexing when there are lots of new documents added?
Any help is greatly appreciated.
Thanks,
Harish
|
|
|