Toad World® Forums

Can I move a TABLE + depending INDEXes to other TABLESPACE?


#1

I would like to move TABLEs (and their depending INDEXes) from one TABLESPACE
to another.
The INDEX move should take place WITHOUT fiddling around with INDEX names
and Rebuilts.

I just want to tell Toad: “Move TABLE aaa and all depending stuff to
TABLESPACE mytablespace123”

Can I do this easily with TOAD or do I have to do it the cumbersome way?

Ben


View this message in context: http://old.nabble.com/Can-I-move-a-TABLE-%2B-depending-INDEXes-to-other-TABLESPACE--tp27608298p27608298.html
Sent from the TOAD mailing list archive at Nabble.com.


#2

Use the toad dbms_redef wizard for this – that’s exactly what
it’s designed for – requires toad dba option


#3

Hi Ben,

Have a look at Database -> Optimize -> Rebuild multiple objects. That screen
will move tables and/or indexes. There are all sorts of options. Hit F1 when you
get there for details.

-John


#4

How do I call the

toad dbms_redef wizard

?
Ben

Bert Scalzo wrote:

Use the toad dbms_redef wizard for this - that’s exactly what it’s
designed for - requires toad dba option


#5

It’s available IF all the following are true:

You are running 10g or higher

You are running Toad v9.5 or higher (I think)

You have the DB Admin module

Database > Optimize > DBMS REDEFINITION WIZARD


#6

From the main menu: Database -> Optimize -> DBMS_REDEFINTION Wizard.
It’s only present if you have the dba module and Oracle 10 or newer.

If the only thing you want to change is tablespace (and index tablespace), and
nobody will be accessing the tables while you are rebuilding them, the Database
-> Optimize -> Rebuild multiple objects is a lot easier. Especially if you have
multiple objects.


#7

Quest has other tools that can do online rebuilds, check out Space Manger/LiveRE

http://www.quest.com/quest_central_for_oracle/live_space_management/space_managem
ent.asp


#8

It was introduced in Toad 9.0


#9

Thanks for the assist J