Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index Tablespaces on ALTER TABLE ADD PARTITION
"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
Received on Thu Feb 16 2006 - 00:10:11 CST