Re: Storage Claus on Partitioned Global Index
Date: Tue, 17 Nov 2009 18:38:33 -0800 (PST)
Message-ID: <752598aa-6042-4fe1-81bb-d11cabd9f553_at_37g2000yqm.googlegroups.com>
On Nov 17, 6:06 pm, joel garry <joel-ga..._at_home.com> 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: inhttp://download.oracle.com/docs/cd/E11882_01/server.112/e10837/part_a...
> :
>
> "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.
Thanks,
Steve Received on Tue Nov 17 2009 - 20:38:33 CST