Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Tablespaces on ALTER TABLE ADD PARTITION
Michel Cadot schrieb:
> "Tiff" <tiffanyherpin_at_yahoo.com> a écrit dans le message de news: 1140040396.015401.26450_at_f14g2000cwb.googlegroups.com...
> | Hello!
> |
> | I support 10.1.0 databases on Solaris 8.
> |
> | We have a database where we are using partitions to store and drop data
> | by calendar quarters. Each quater gets a new partition in a given
> | table and consequently, the old partition gets dropped.
> |
> | We can add partitions just fine, but it seems that Oracle is plopping
> | the index into the user's default tablespace. I've combed through the
> | SQL Reference guide and can't find a way to designate which tablespace
> | we want to use for the index on an ALTER TABLE ADD PARTITION command.
> |
> | Any ideas?
> |
> | Thanks!
> |
> | Tiffany
> |
>
> Move the new index partition to the wanted tablespace afterwards
> (alter index ... rebuild partition ... tablespace ...).
> It is immediate as the partition is empty.
>
> Regards
> Michel Cadot
>
>
Or, alternatively, if you wish to have all new index partitions to be created in the certain tablespace, you can issue: ALTER INDEX <your_index> MODIFY DEFAULT ATTRIBUTES TABLESPACE <your_desired_index_tablespace>;
Best regards
Maxim Received on Thu Feb 16 2006 - 04:41:17 CST