move indexes?

[nirasha]

I would like to know what happens when I issue the:
alter table move tablespace command?

What happens to the primary key etc? I am trying to get all of the objects off a particular tablespace. How do I move indexes?

Thanks,
Nirasha

[rsuri]

you will have to move individual indexes as well --

alter index <<test>> rebuild tablespace <<indx>>;

- Rajeev

[Chandra]

You can try with rebuild command.
Good Luck