ORA-24383: Overflow segment of an IOT cannot be described
Team,
SQL> desc ABC.SYS_IOT_OVER_172191
ERROR:
I have a requirement where I've to give the structure of the table "SYS_IOT_OVER_172191". However when I describe the table I get the below error.
Can you pls suggest. Below is the log of the same.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select owner ,object_name,object_type
2 from dba_objects
3 where object_name='SYS_IOT_OVER_172191';
OWNER OBJECT_NAME OBJECT_TYPE
---------- ------------------------------ --------------------
ABC SYS_IOT_OVER_172191 TABLE
---------- ------------------------------ --------------------
ABC SYS_IOT_OVER_172191 TABLE
1 row selected.
SQL> desc ABC.SYS_IOT_OVER_172191
ERROR:
0