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
Printable View
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
you will have to move individual indexes as well --
alter index <> rebuild tablespace < >;
- Rajeev
You can try with rebuild command.
Good Luck