alter table A move tablespace TB1
Posted on 2007-03-22
I want to move a table A using tablespace TB1 to tablespace TB2. In order to achieve this, i can issue " alter table A move tablespace TB2" , but my question is can we do it on fly? or do we have to restrict anything before carrying this out? And also if the table has any indexes or constraints, is it necessary to move them too? or are they not affected by this?