How to you change the default storage parameter for the CS_INCIDENTS_ALL_TL_N1 domain index?

(Doc ID 357532.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 21-AUG-2013***


Goal

How do you change the default storage parameter for the CS_INCIDENTS_ALL_TL_N1 domain index?

NOTE: You may have gotten the following error in the logfile when running "Service Request:
Synchronize Text Index Program":

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Sync_Text_Index: CS_INCIDENTS_ALL_TL_N1 :Execution failed due to unexpected
error. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dreii0fsh
ORA-01631: max # extents (2048) reached in table CS.DR$CS_INCIDENTS_ALL_TL_N1$I

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms