Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Should an IOT be listed in the DBA_SEGMENTS VIEW

Re: Should an IOT be listed in the DBA_SEGMENTS VIEW

From: Chris O'Sullivan <itoys_at_tpg.com.au>
Date: Wed, 28 Nov 2001 09:04:47 +1000
Message-ID: <3c040d90@dnews.tpgi.com.au>


Scott, this is NOT a bug. The IOT storage is in the index segment for its primary key.

"Scott Watson" <rscottwatson_at_hotmail.com> wrote in message news:a25846ac.0111271348.26e93549_at_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 - 17:04:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US