| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: index_organized tables... is this normal?
An index-organized table is not really a table so that is
correct. I have a couple of them out there and they are
working ok but one really annoying thing is they cannot
be exported/imported. Caused me a few issues already.
Keep that in mind. And TOAD can not show the data in the
browser, however you can select the data in the sql window.
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Thursday, September 14, 2000 4: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
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-LReceived on Fri Sep 15 2000 - 10:33:48 CDT
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
 |
 |