Yes, it is normal. I think it should be that way because DBA_OBJECTS
contains ALL object 'types', so table name and index name (for constraint)
should appear there. DBA_SEGMENTS always reported only the 'physical'
objects taking up space. And in this case the 'index' is that object.
- Kirti
> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Thursday, September 14, 2000 6:12 PM
> To: Multiple recipients of list ORACLE-L
> Subject: index_organized tables... is this normal?
>
> Okay, I started to play around with index-organized tables. I created a
> table where the primary key is a composite key, all the columns in the
> table
> (well that's WHY it's index-organized).
>
> Table name and constraint name are different.
>
> When I look in dba_objects, I see both names, table name as type table,
> constraint name as type index.
>
> I can access the table name and get information.
>
> When I look in dba_segments, I only see the index name. Is it supposed to
>
> be like this?
>
> Wery interesting Mr Wabbit
>
> Rachel
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Sep 15 2000 - 08:26:36 CDT
