Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index Tablespaces on ALTER TABLE ADD PARTITION

Re: Index Tablespaces on ALTER TABLE ADD PARTITION

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 16 Feb 2006 07:10:11 +0100
Message-ID: <43f41742$0$1232$636a55ce@news.free.fr>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US