Lob Index Without Lob Segment
(Doc ID 1583220.1)
Last updated on JANUARY 07, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.4 [Release 10.1 to 11.2]Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |