oracle数据库中转移表空间

select 'alter table ' || table_name || ' move tablespace 新的表空间名称;' from dba_tables T where tablespace_name = '原有表空间' AND T.owner = '数据库实例名';

 

select 'alter index ' || index_name || ' REBUILD TABLESPACE 新的表空间名称;' from dba_indexes where table_name in (select table_name from dba_tables where tablespace_name = '原有表空间'  AND owner = '数据库实例名');

 

imp userid=uid/password file=e:\mimi16.dmp fromuser= user1 touser=user2 tablespaces= 表空间