1

Topic: ORA-08005 At reading

Request

select max (bi.corracc) keep (dense_rank last order by bi.validtodate) into corracc
from bankbik bi
where bi.bik = p_bik
and nvl (bi.validfromdate, 19000101) <= dt and nvl (bi.validtodate, 44440101)> dt;

In one of days produced an error
ORA-08005: the given line does not exist
To what can be connected?
bankbik - the normal heap-tablet, one index.
[sub] Nobody faults but mine... (LZ) [/sub]

2

Re: ORA-08005 At reading

aag;
Here that write about it on asktom.oracle.com:

wrote:

There is a bug affecting parallel queries on subpartitioned tables with bitmap indexes (see MOS note 1591955.1).
If this not your issue it could be that you have some corruption - e.g. in an index has invalid rowids for some reason (though this should raise an ORA-01410).
In either case, if this is causing you issues then contact support.

3

Re: ORA-08005 At reading

flexgen ;
I read it. But here the trouble - is not present at me parallel reading under this table,  indexes. And subpartition too is not present, there only 12  records.

4

Re: ORA-08005 At reading

aag;
Rebuild an index and check up.

5

Re: ORA-08005 At reading

aag;
And in alert.log something is available concerning this error?

6

Re: ORA-08005 At reading

dt - what data type?

7

Re: ORA-08005 At reading

env
The index yet did not rebuild, but the table after this error very actively  some days. Without errors. That is, such request (it is caused function in request), is caused some honeycombs of times in day.
Lary Denis
number. Contains date in a format yyyymmdd.
flexgen
I can not learn yet.