oer 8102.2 - obj# 52466, rdba: 0x04ccddb7(afn 19, blk# 843191)

*** SESSION ID:(607.25530) 2010-11-29 19:45:06.970
oer 8102.2 - obj# 52466, rdba: 0x04ccddb7(afn 19, blk# 843191)
kdk key 8102.2:
  ncol: 2, len: 14
  key: (14):  06 44 6f 63 4b 65 79 06 03 82 da 91 00 00
  mask: (4096):

 

*** 2010-11-29 19:45:06.986
ksedmp: internal or fatal error
Current SQL statement for this session:
DELETE FROM VANUSER.DOCUMENTATTR WHERE DOCUMENTINFOID = :B1
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x6b91f4d0        97  procedure VANUSER.VANPURGE
0x6db49eb8         1  anonymous block

*****************************************

select owner,object_name,object_type from dba_objects where object_id=52466

OWNER                   OBJECT_NAME               OBJECT_TYPE
----------------- -------------------------- -------------------
VANUSER             DOCUMENTATTRATTRVALUE            INDEX
******************************************************************************
  1* select * from dba_ind_columns where table_name='DOCUMENTATTR'  order by 2,6
SQL> /

INDEX_OWNER                    INDEX_NAME                     TABLE_OWNE TABLE_NAME      COLUMN_NAME          COLUMN_POSITION COLUMN_LENGTH CHAR_LENGTH DESC
------------------------------ ------------------------------ ---------- --------------- -------------------- --------------- ------------- ----------- ----
VANUSER                        DOCATTR_NAME_VALUE             VANUSER    DOCUMENTATTR    ATTRVALUE                          1            50          50 ASC
VANUSER                        DOCATTR_NAME_VALUE             VANUSER    DOCUMENTATTR    ATTRNAME                           2            50          50 ASC
VANUSER                        DOCUMENTATTRATTRVALUE          VANUSER    DOCUMENTATTR    ATTRNAME                           1            50          50 ASC
VANUSER                        DOCUMENTATTRDOCUMENTINFOID     VANUSER    DOCUMENTATTR    DOCUMENTINFOID                     1            22           0 ASC
VANUSER                        PK_DOCATID                     VANUSER    DOCUMENTATTR    DOCUMENTATTRID                     1            22           0 ASC
********************************************************************************
The following SQL statement returned no results
SELECT /*+ FULL(t1) */ ATTRNAME
FROM VANUSER.DOCUMENTATTR  t1
MINUS
SELECT /*+ index(t2 DOCUMENTATTRATTRVALUE) */ ATTRNAME
FROM VANUSER.DOCUMENTATTR t2;
The following SQL statement returned wrong results,it should be no results.
select /*+ FULL(t1) */ DOCUMENTINFOID
FROM VANUSER.DOCUMENTATTR t1
MINUS
select /*+ INDEX(t2 DOCUMENTATTRDOCUMENTINFOID) */  DOCUMENTINFOID
FROM VANUSER.DOCUMENTATTR t2;