Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-08102 with function based index (NLS_SORT)

ORA-08102 with function based index (NLS_SORT)

From: <francois.archambault5_at_gmail.com>
Date: Mon, 26 Nov 2007 08:46:23 -0800 (PST)
Message-ID: <6bfd56e8-0a4d-4490-8d8f-edb66d3e2b50@s8g2000prg.googlegroups.com>


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

where IKALLERGY_REF = 82;
commit;

update allergy_ref
set CALLERGY_REF = 'chat',
CCODE_INTERFACE = 'a1',
BDESACTIVE = 0,

CCODE_1_OUT = NULL,
CCODE_2_OUT = NULL,
CCODE_3_OUT = NULL

where IKALLERGY_REF = 82;
commit;

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 :

--

--

Received on Mon Nov 26 2007 - 10:46:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US