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 是,表示自包含
**********************************************
对于一件事情,往往超过我们的想象,自信、坚持,勇往直前!
参与者:Rainbow Gu
地址:南都
***********************************************