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 -> Re: Can I store data in the indexes and not the tables ?

Re: Can I store data in the indexes and not the tables ?

From: Stephen Vear <vears_at_logica.com>
Date: Thu, 18 Mar 1999 17:05:47 +0100
Message-ID: <7cr89a$db8@romeo.logica.co.uk>


Unfortunately Oracle 8 also features table partitioning which we have implemented on the tables in question.

And you cannot use table partitioning on a IOT table.

Thanks all the same.
Stephen

Jim Kennedy wrote in message ...
>In Oracle 8 you can have an IOT (Index Organized Table) which is what you
>are probably looking for.
>Jim
Received on Thu Mar 18 1999 - 10:05:47 CST

Original text of this message

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