Cluser bug ! URGENT ....

[mahoori]

Hi all.
platform : win2000 server ,
oracle8i(8.1.7.0.0) enterprise edition.


I have 2 table GADOCMT and GADOCDT that clusterd on
(GAYEAR_YEAR,TEMPDOC_NO).
this 2 field are PK of GADOCMT.

one record with GAYEAR_YEAR=1381 and TEMPDOC_NO=10514 exists in table GADOCMT but followin query returns no record :

SQL> select *
from gadocmt
where tempdoc_no=10514 and gayear_year=1381;

no rows selected

explain plan show this query use cluster scan.


but following query that uses PK INDEX of GADOCMT returns record.
SQL> SELECT /*+ INDEX (GADOCMT GADOCM_PK) */ *
from gadocmt
where tempdoc_no=10514 and gayear_year=1381;

FINALDOC_NO FINAL_SEQ GAYEAR_YEAR GATYPO_SRL TEMPDOC_NO UAUSER_SRL DOC_DATE USER_SRIAL DES
----------- ---------- ----------- ---------- ---------- ---------- ---------- ---------- ----------
1381 15 10514 512 1381/04/30 0 ÓäÏ ÇäÊÞÇá

following query use cluster index but all select fields fetch from cluster index and no reference to cluster neeeded.
SQL> SELECT tempdoc_no,gayear_year
from gadocmt
where tempdoc_no=10514 and gayear_year=1381;

TEMPDOC_NO GAYEAR_YEAR
---------- -----------
10514 1381


I guess poinetr in cluster index that point to this recoed destroyed .
I rebuild cluster index but still problem exists.

Please help me.
-- sorry for my english.

Best regards.

[mahoori]

Hi all.
I am waiting for reply.