| 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?
Makes sense that you can't export them (since they are indexes).
Fortunately, the data in the table is loadable from flat files (although the
"used" flag isn't)
I don't usually use TOAD (I'm a SQL*Plus sort of gal myself) so that's not going to be a problem :)
Thanks
>From: Kimberly Smith <kimberly.smith_at_gmd.fujitsu.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: index_organized tables... is this normal?
>Date: Fri, 15 Sep 2000 08:36:48 -0800
>
>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-----
>Sent: Thursday, September 14, 2000 4:12 PM
>To: Multiple recipients of list ORACLE-L
>
>
>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).
>--
>Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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).
Share information about yourself, create your own public profile at Received on Fri Sep 15 2000 - 11:17:49 CDT
 |
 |