Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to stop a current indexation ? (a document is blocking)

DPRMJan 20 2015 — edited Jan 23 2015

Hello,

I have an Oracle Text domain index which is blocking. Before creating the index I activated the logging with these 2 commands :

execute CTXSYS.CTX_OUTPUT.START_LOG('logfile.log');

exec ctx_output.add_event(CTX_OUTPUT.EVENT_INDEX_PRINT_ROWID);

Therefore I can see in my log the document which is blocking. I have this row there for hours is my log :

09:32:11 01/20/15 INDEXING ROWID AAAEotAAAAAK2XzAAB

It tells it's indexing for hours on a Zip file which is only 200 ko. Can somebody tell me how I can tell Oracle Text to abort the indexation of this file and continue with the remaining one in the ctxsys.dr$pending table ?

I don't want to delete my index and start all again because I already did it 10 times in order to be able to activate logging...

Thank you for your help.

zigune

This post has been answered by kevinUCB on Jan 20 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2015

Added on Jan 20 2015

#database-key-features, #text

14 comments

2,815 views