Should an IOT be listed in the DBA_SEGMENTS VIEW

From: Scott Watson <rscottwatson_at_hotmail.com>
Date: 27 Nov 2001 13:48:14 -0800
Message-ID: <a25846ac.0111271348.26e93549@posting.google.com>

Is anyone aware of a bug on 8.1.7 where an IOT is not listed in the dba_segments view. (running on NT) Or are IOTs just not listed in this view for whatever reason.

SQLPLUS> select * from dba_segments where segment_name =
'SIMPLE_GUI_DETAIL';
no rows selected

SQLPLUS > select * from dba_objects where object_name =
'SIMPLE_GUI_DETAIL';

OWNER                          OBJECT_NAME                   
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID
------------------------------ ------------------------------
------------------------------ ---------- --------------
OBJECT_TYPE        CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G

S

------------------ --------- --------- ------------------- ------- - -
-
PUBLIC                         SIMPLE_GUI_DETAIL                      
                            3838
SYNONYM            01-NOV-01 01-NOV-01 2001-11-01:10:08:24 VALID   N N

N

OLNAPP                      SIMPLE_GUI_DETAIL                         
                         3712
TABLE              24-OCT-01 24-OCT-01 2001-10-24:15:06:29 VALID   N N

N

SQLPLUS> select table_name, IOT_TYPE from dba_tables where table_name = 'SIMPLE_GUI_DETAIL';

TABLE_NAME                     IOT_TYPE
------------------------------ ------------
SIMPLE_GUI_DETAIL              IOT

SQLPLUS> select count(*) from simple_gui_detail;

  COUNT(*)

---

       146

Thanks,
Scott Watson. Received on Tue Nov 27 2001 - 15:48:14 CST