Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Index Organized Tables | What tablespace?

Index Organized Tables | What tablespace?

From: <kwagner_at_watchmark.com>
Date: Mon, 02 Oct 2000 20:28:16 GMT
Message-ID: <8rar4k$7p7$1@nnrp1.deja.com>

Howdy,

     How can I determine what tablespace an IOT has been created in (when no overflow exists)? The tablespace_name column in dba_tables is null in every occurance of IOT and these objects to not appear in dba_segments or dba_indexes.

???
Kevin Wagner

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 02 2000 - 15:28:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US