Oracle command Summary-data migration

Chapter 6: load data

    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 

Chapter 7: 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); 

View in Table transport_set_violations

SQL> If dbms_tts.isselfcontained is true, it indicates self-contained