expdp impdp 表中列的顺序不同 列不存在的情况

 exppar

directory= 
dumpfile=test_exp_0317%U.dmp
SCHEMAS= 
compression=DATA_ONLY
logfile=test_exp_0317.log
INCLUDE=TABLE:"IN ('TEST')"
cluster=no
#ACCESS_METHOD=EXTERNAL_TABLE
#ACCESS_METHOD=DIRECT_PATH

imppar

directory= 
SCHEMAS= 
remap_schema= 
remap_table=test:test2
dumpfile=test_exp_0317%U.dmp
logfile=tst_0402_imp.log
cluster=no
table_exists_action=truncate
#parallel=16
 

export from:

select *From test;

        T1         T2         T3
---------- ---------- ----------
         1          2          3

import when column order is not same

  select *from test1;     顺序不对 ，自动对应

        T2         T1         T3
---------- ---------- ----------
         2          1          3

import when column not  exists

  select *From test2;  少一列，数据丢失

        T4         T1         T3
---------- ---------- ----------
                    1          3