Re: Storage Claus on Partitioned Global Index
From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 17 Nov 2009 20:08:41 +0000 (UTC)
Message-ID: <pan.2009.11.17.20.08.41_at_email.here.invalid>
On Tue, 17 Nov 2009 11:49:38 -0800, UXDBA wrote:
Date: Tue, 17 Nov 2009 20:08:41 +0000 (UTC)
Message-ID: <pan.2009.11.17.20.08.41_at_email.here.invalid>
On Tue, 17 Nov 2009 11:49:38 -0800, UXDBA wrote:
> SQL>
>
> Questions:
> Do the the line : TABLESPACE USERS
> in "CREATE INDEX " statement is redundant ? As all Index segments (
> partitioned ) got created in "DATA" tablespace.
>
> Regards
Of course they got created in the tablespace data when you specified that! Both of the index partitions are created with the "tablespace data" option. What did you expect to be created in the tablespace users?
-- http://mgogala.byethost5.comReceived on Tue Nov 17 2009 - 14:08:41 CST