Oracle 命令大匯總-資料移轉

第六章：load資料 

    1.loading data using direct_load insert 

    sql> insert /*+append */ into emp nologging 

    sql> select * from emp_old; 

    2.parallel direct-load insert 

    sql> alter session enable parallel dml; 

    sql> insert /*+parallel(emp,2) */ into emp nologging 

    sql> select * from emp_old; 

    3.using sql*loader 

    sql> sqlldr scott/tiger \ 

    sql> control = ulcase6.ctl \ 

    sql> log = ulcase6.log direct=true 

第七章：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 是， 表示自包含