Home » SQL & PL/SQL » SQL & PL/SQL » ORA-03113 when using descending index
icon5.gif  ORA-03113 when using descending index [message #189440] Thu, 24 August 2006 10:32 Go to next message
Messages: 1
Registered: August 2006
Junior Member
I've got the following problem with Oracle 10.1 and 10.2 databases:

We are using descending indexes in our application which worked well with Oracle 8i/9i databases. But with Oracle 10g there are often ORA-03114 errors when a descending index is used.

I can reproduce this errors with some small code on the sqlplus command-line:

create table tn_test (A number(10), B varchar2(10));

create index idx_tn_test on tn_test(A desc, B desc);

insert into tn_test (A,B) values ( 1,'123');

select A from tn_test where B = '123' and ((A = 0) or (A = 1));

-> ORA-03113: end-of-file on communication channel

Has someone an idea?

[Updated on: Thu, 24 August 2006 10:36]

Report message to a moderator

Re: ORA-03113 when using descending index [message #189450 is a reply to message #189440] Thu, 24 August 2006 11:55 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
I can confirm this on on Windows. I see a lot of references to ORA-03113 and descending indexes on Metalink, but almost all related to 8i.

I would suggest opening a Service Request with Oracle Support.
Previous Topic: Store a text file into CLOB column
Next Topic: Before Insert trigger - Skip Insert
Goto Forum:

Current Time: Sun Aug 20 03:05:12 CDT 2017

Total time taken to generate the page: 0.04963 seconds