Re: Storage Claus on Partitioned Global Index

From: Steve Howard <>
Date: Tue, 17 Nov 2009 18:38:33 -0800 (PST)
Message-ID: <>

On Nov 17, 6:06 pm, joel garry <> wrote:

> Maybe I'm not reading all this correctly,

No, believe me, I'm sure it's me, as I always feel a little stupid about this stuff, and just need to dig into the docs to ensure I understand the usage of defaults. Given the fact you, Mladen, and Nuno all seem to have a handle on it, I'm sure I just need to invest the time to get up to speed.

> but since you've defined tablespaces for every partition under maxvalue, > wouldn't everything go into defined tablespaces?  

This would make sense for the original partitions at creation, but I don't understand why a split (which effectively adds a new partition P4 in my example without a tablespace clause) doesn't go into the "default" USERS tablespace (whatever that means).

> From the Note: in
> :
> "Any attributes you do not specify are inherited from the original
> partition."  Of course, that is talking about tables, so the docs
> ought to mention the same thing about indices.

I'm not sure what "original partition" means in that case? What if I created two partitions in two different tablespaces "originally"?

I'll dig into this and see if I can figure it out.


Steve Received on Tue Nov 17 2009 - 20:38:33 CST

Original text of this message