Lob Index Without Lob Segment (Doc ID 1583220.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

 LOB INDEX WITHOUT LOB SEGMENT :

SQL> select OWNER , OBJECT_NAME ,  OBJECT_TYPE , STATUS  from dba_objects where object_name='SYS_IL0000082926C00003$$';

OWNER                          OBJECT_NAME                   OBJECT_TYPE     STATUS    
------------------   ----------------------------             -----------------    ----------   
TEST         SYS_IL0000082926C00003$$        INDEX               VALID  

  

SQL> select OWNER,INDEX_NAME,INDEX_TYPE,TABLE_OWNER,TABLE_NAME,TABLESPACE_NAME from dba_indexes where INDEX_NAME='SYS_IL0000082926C00003$$';

OWNER                          INDEX_NAME                     INDEX_TYPE                  TABLE_OWNER                    TABLE_NAME                     TABLESPACE
------------------------------ ------------------------------ --------------------------- ------------------------------ ------------------------------ ----------
TEST                     SYS_IL0000082926C00003$$       LOB                         TEST                               TEST_TABLE               DATA2

SQL> select * from dba_lobs where TABLE_NAME='TEST_TABLE';

no rows selected

SQL> select * from dba_lobs where INDEX_NAME='SYS_IL0000082926C00003$$';

no rows selected

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms