Re: Index Organized Tables | What tablespace?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 3 Oct 2000 19:22:12 +0100
Message-ID: <970598165.15505.2.nnrp-10.9e984b29@news.demon.co.uk>

select index_name, tablespace_name from dba_indexes where table_name = '{iot table}'

The table is stored as its primary key index.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

kwagner_at_watchmark.com wrote in message <8rar4k$7p7$1_at_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 Tue Oct 03 2000 - 13:22:12 CDT