传输表空间只传输新的表

创建表空间
create tablespace abctest1
datafile '/oradata/ORCL/datafile/test_1.dbf' size 10M;


create tablespace abctest2
datafile '/oradata/ORCL/datafile/test_2.dbf' size 10M;


创建用户
create user test identified by oracle_4U
default tablespace abctest1
temporary tablespace temp; 


grant create session, resource to test;


conn test/oracle_4U


创建两个表指定不同表空间
CREATE TABLE test1 tablespace abctest1 as select * from all_objects where rownum<1000;
CREATE TABLE test2 tablespace abctest2 as select * from all_objects where rownum<100;


验证数据情况
select count(*) from test1;
select count(*) from test2;


验证表所属表空间
select tablespace_name,table_name from user_tables;


传输检查
exec dbms_tts.transport_set_check('ABCTEST2',TRUE);


检查传输限制
select * from transport_set_violationss;


指定表空间为只读
alter tablespace abctest2 read only;


数据导出
exp \'sys/oracle_4U as sysdba\' file=test2.dmp transport_tablespace=y tablespaces=abctest2 log=test2_tts.log


备份及清理
cp /oradata/ORCL/datafile/test_2.dbf /oradata/ORCL/datafile/test_2.dbf1


drop table test.test1 purge;
drop tablespace abctest2 including contents and datafiles cascade constraint;


确定数据文件句柄已经释放
!ls -l /oradata/ORCL/datafile/test_2.dbf


重命名数据文件
!mv /oradata/ORCL/datafile/test_2.dbf1 /oradata/ORCL/datafile/test_2.dbf


表空间导入
imp \'sys/oracle_4U as sysdba\' file=test2.dmp transport_tablespace=y tablespaces=abctest2 log=test2_tts.log datafiles=/oradata/ORCL/datafile/test_2.dbf


表空间置为读写
alter tablespace abctest2 read write;


数据检查
select tablespace_name,table_name from user_tables;