On Friday 14 September 2007, "Harsh Azad" <harsh(dot)azad(at)gmail(dot)com> wrote:
> Great, creating new tablespace for indexes worked! Now the question is
> whether existing tables/index can be moved to the new tablespace using an
> alter command or the only way possible is to drop and recreate them?
>
ALTER TABLE table_name set tablespace new_tablespace;
and ALTER INDEX ...
--
Eat right. Exercise regularly. Die anyway.