Re: moving tables from one tablespace to another

alter table <owner>.<tablename> move tablespace <tablespace_name>;

but it works only if no lob objects are columns in the table to be moved

the other way then is to drop all constraints for the specific table drop all indexes

rename the table to tmptable
create the table in the newly tablespace insert into table as select from tmptable recreate the constraints
recreate the indexes

or

exp the table
apply the users default tablespace as tomove tablespace alter the frommove tablespace offline
imp table

--
Posted via http://dbforums.com