index_organized tables... is this normal?

From: Rachel Carmichael <carmichr_at_hotmail.com>
Date: Thu, 14 Sep 2000 20:39:12 GMT
Message-Id: <10619.117019@fatcity.com>

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. Received on Thu Sep 14 2000 - 15:39:12 CDT