> ----------
> From: Rachel Carmichael[SMTP:carmichr_at_hotmail.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, September 15, 2000 01:12
> 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?
Yes, as the whole table is contained in the index segment.
> 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 - 06:42:29 CDT
