Database DataWarehousing (MOSC)

MOSC Banner

Need to move table partitions to a different tablespace

edited Jan 14, 2010 1:23AM in Database DataWarehousing (MOSC) 7 commentsAnswered
  Hello Dear experts,

I have a question regarding table partitions move. My environment is below:

10gR2 , 2-node RAC on Solaris 10 (Sun sparc-64 bit) with Veritas VCS

I have a lot of table partitions (range based) with Local indexes in production that I need to move to a different tablespace.
I am aware that this can be accomplished with

ALTER TABLE <table_name> MOVE PARTITION <partition_name> TABLESPACE <new_tablespace_name>;


My questions are :

Do I need to explicitly move the Local Index partitions or would these move automatically?
Would this make any partitioned indexes unsuable?
Would I need to re-build the index partitions in the new tablespace?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center