First, use the following command to move: alter table table_name move tablespace tablespace_name; Then, if the index must be rebuilt if the index: alter index index_name rebuild tablespace tablespace_name; of course, be used to help achieve spool .set header off operation of a plurality of tables; spool /export/home/oracle/alter_tables.sql;select 'alter table' || object_name || 'move tablespace users'from dba_objectwhere owner =' XXX 'and object_type =' TABLE '; spool off; i.e., after executing this script sql Yes. Also do the same operation for Index.
