Home » Server Options » Text & interMedia » create index hangs (oracle 10g r1)
create index hangs [message #396188] Sat, 04 April 2009 16:12 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Hello

We recreate the text indexes because of their large sizes. Instead of rebuilding we planned for the following steps
1. drop the index
2. create the index with the populate option
However some of the indexes are recreated successfully. one of the text index hangs for an infinite time .
please let me know why ? and how to troubleshoot it.



Regards
Ankush
Re: create index hangs [message #396190 is a reply to message #396188] Sat, 04 April 2009 16:15 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
command used to create the index

CREATE INDEX <index> ON <table> (column)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('language column fts_lang
datastore MAM_TEXT_DATASTORE
filter ctxsys.null_filter
wordlist MAM_WORDLIST
lexer MAM_LEXER_MC
stoplist MAM_STOPLIST
section group ctxsys.null_section_group
storage MAM_STORAGE_PREF
populate')
NOPARALLEL;


Can we mention nologging option to do the process faster..
Re: create index hangs [message #396215 is a reply to message #396190] Sun, 05 April 2009 02:07 Go to previous message
Barbara Boehmer
Messages: 9077
Registered: November 2002
Location: California, USA
Senior Member
You can query ctx_user_index_errors and there are some tips for speeding up indexing in the link below. However, looking at some of the titles of your other posts about other things hanging and failing and error messages and such it sounds like you may have some major system problems, not specifically related to just Oracle Text. If you have support, it is probably time to contact them.

http://download.oracle.com/docs/cd/B19306_01/text.102/b14217/aoptim.htm#sthref779
Previous Topic: Fuzzy logic data unit tests
Next Topic: Space in Lexer
Goto Forum:
  


Current Time: Thu Mar 28 11:20:51 CDT 2024