Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-08102 with function based index (NLS_SORT)
Hi,
We went across the following problem on our 10.1.0.3 Oracle database on windows 2003.
Problem :
After multiple updates on an index organized table with a function
based index, the error ORA-08102 appears.
Error situation :
The error appears to come up only with the letters 'CH' but not sure.
The errors doesnt appear when we remove the function based index.
Execute the following commands multiple times to make the error
appear:
Update allergy_ref
set CALLERGY_REF = 'chata',
CCODE_INTERFACE = 'a1',
BDESACTIVE = 0,
CCODE_1_OUT = NULL, CCODE_2_OUT = NULL, CCODE_3_OUT = NULL
update allergy_ref
set CALLERGY_REF = 'chat',
CCODE_INTERFACE = 'a1',
BDESACTIVE = 0,
CCODE_1_OUT = NULL, CCODE_2_OUT = NULL, CCODE_3_OUT = NULL
Temporary solution :
- Rebuild index : The error disapear for a while but reappear after
the error situation is repeated.
- Recreating index : Same result has rebuild index
- Recreating table and index : Same result
Table and Index DML :
--
--
![]() |
![]() |