ORA-00604 PLS-00103 Errors Encountered Splitting The Maxvalue Partition Of Table With Text Index (Doc ID 734881.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version: 10.2.0.1
This problem can occur on any platform.

Symptoms

Trying to add a partition to a table by splitting the maxvalue partition.
The split fails, leaving the text index in unusable state   

    
alter table TABLE_NAME_THAT_IS_30CHARSLONG split partition PARTITION_LAST
 *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06550: line 2, column 187:
PLS-00103: Encountered the symbol "SCOTT" when expecting one of the following:
) , * & | = - + < / > at in is mod remainder not rem => ..
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_

A drop index force fails:

drop index TEXT_IDX force;

ERROR at line 1: 
ORA-00604: error occurred at recursive SQL level 1 
ORA-06550: line 2, column 187: 
PLS-00103: Encountered the symbol "SCOTT" when expecting one of the following: 
) , * & | = - + < / > at in is mod remainder not rem => .. 
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ 
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_

Index does not exist in dr$index but it does exist in user_indexes: 

    
select * from ctxsys.dr$index where idx_name='TEXT_IDX';
  no rows selected
    
select index_name from user_indexes where index_name='TEXT_IDX'; 
INDEX_NAME 
------------------------------ 
TEXT_IDX

Cause

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