How to move 3 indexes of a tablespace for another one? without using export or recreate????
hhbrazil, ALTER INDEX with the rebuild clause placing the "rebuilt" index into a new tablespace with new allocation parameters...
Question , when I use rebuild cluasule , this index are move to a new tblspc??
hhbrazil, The index WILL move if you specify a different tablespace in the parameters of the rebuild clause...
OK. thank you for its attention, they are little the people that only help the other ones for the pleasure of helping like you.. your attention.
Forum Rules