OraFAQ Forum: Text & interMedia » create index hangs

Home » Server Options » Text & interMedia » create index hangs (oracle 10g r1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

create index hangs [message #396188]

Sat, 04 April 2009 16:12

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

Report message to a moderator

Re: create index hangs [message #396190 is a reply to message #396188]

Sat, 04 April 2009 16:15

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..

Report message to a moderator

Re: create index hangs [message #396215 is a reply to message #396190]

Sun, 05 April 2009 02:07

Barbara Boehmer
Messages: 9104
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

Report message to a moderator

Previous Topic:	Fuzzy logic data unit tests
Next Topic:	Space in Lexer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 19:08:46 CST 2025