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