Oracle数据库命令速查手册 -reorganizing data

1.using expoty 
$exp scott/tiger tables(dept,emp) file=c:\emp.dmp log=exp.log compress=n direct=y 
2.using import 
$imp scott/tiger tables(dept,emp) file=emp.dmp log=imp.log ignore=y 
3.transporting a tablespace 
sql>alter tablespace sales_ts read only; 
$exp sys/.. file=xay.dmp transport_tablespace=y tablespace=sales_ts 
triggers=n constraints=n 
$copy datafile 
$imp sys/.. file=xay.dmp transport_tablespace=y datafiles=(/disk1/sles01.dbf,/disk2 
/sles02.dbf) 
sql> alter tablespace sales_ts read write;
4.checking transport set 
sql> DBMS_tts.transport_set_check(ts_list =>'sales_ts' ..,incl_constraints=>true); 
在表transport_set_violations 中查看 
sql> dbms_tts.isselfcontained 为true 是，表示自包含