Index Tablespaces on ALTER TABLE ADD PARTITION

From: Tiff <tiffanyherpin_at_yahoo.com>
Date: 15 Feb 2006 13:53:16 -0800
Message-ID: <1140040396.015401.26450@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 Received on Wed Feb 15 2006 - 15:53:16 CST