Re: 8i Index-Organized Tables Question?

I would always advise a strategy of using the default settings for a tablespace and never using explicit object settings but,

You are allowed two storage clauses, one for the Index segment and one for the overflow segment:

create table ......

organization index
storage (initial ......)
pctthreshold 20
overflow
storage (initial .....)

--

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

Erik wrote in message <7m34p5$nkk$1_at_nnrp1.deja.com>...
>
>
>Hello,
>I have been working on creating an Index-Organized Table (8i feature).
>I have been able to create an index organized table on a 2GB existing
>table, but the primary key for the index-organized table has a large
>number of extents (over 14,000). I have not been able to find a way to
>specify the storage for the primary key on the index-organized table at
>creation time.
Received on Fri Jul 09 1999 - 02:41:09 CDT