Oracle 11.2.0.3.0 , Exadata ， 使用类似如下语句做expdp 导出时，报错
nohup expdp \'/as sysdba\' directory=dumptemp dumpfile=tofus0220_24.dmpdp logfile=tofus0220_24.dmpdp.out.log compression=all tables=\
MCA.MCA_LOSS_PRO_JOURNALS_DT_T,\
DMREG.DM_REG_AR_CFS_R3AC0_SUM_F,\
DMACC.DM_ADP_CF_AB_R0AC0_SUM_F,\
MCA.DWR_FIN_ADJUST_JE_DT_T &
MCA.MCA_LOSS_PRO_JOURNALS_DT_T,\
DMREG.DM_REG_AR_CFS_R3AC0_SUM_F,\
DMACC.DM_ADP_CF_AB_R0AC0_SUM_F,\
MCA.DWR_FIN_ADJUST_JE_DT_T &
报错信息如下：
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_5" 419.2 MB 2690812 rows
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_5" 339.8 MB 2376168 rows
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_13" 360.4 MB 2335455 rows
ORA-31693: Table data object "DMCON"."DM_DEV_RD_EXP_SUM_F":"P201210" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_13" 334.8 MB 2206227 rows
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_14" 333.6 MB 2120226 rows
ORA-31693: Table data object "DMCON"."DM_DEV_RD_EXP_SUM_F":"P201209" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
ORA-31693: Table data object "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_11" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
ORA-31693: Table data object "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_14" failed to load/unload and is being skipped due to error:
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_5" 339.8 MB 2376168 rows
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_13" 360.4 MB 2335455 rows
ORA-31693: Table data object "DMCON"."DM_DEV_RD_EXP_SUM_F":"P201210" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_13" 334.8 MB 2206227 rows
. . exported "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_14" 333.6 MB 2120226 rows
ORA-31693: Table data object "DMCON"."DM_DEV_RD_EXP_SUM_F":"P201209" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
ORA-31693: Table data object "MCA"."DWR_AR_BALANCE_DT_T":"P201302R01"."P201302R01_SUBHASH_11" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01466: unable to read data - table definition has changed
ORA-31693: Table data object "MCA"."DWR_AR_BALANCE_DT_T":"P201301R02"."P201301R02_SUBHASH_14" failed to load/unload and is being skipped due to error:
查询了一下， 说是在导出过程中对表有ddl操作， 使用如下语句查询了一下，买糕的，果然一直都有很多表在做ddl
操作，可能是权限或其他操作。 导致导出报错， 是否有好的方法避免这种报错， 还在查找中。
select owner,object_name,object_type,last_ddl_time from sys.dba_objects where owner<>'SYS' and last_ddl_time between to_date('2013/02/21 17:00:00','YYYY/MM/DD HH24:MI:SS') and to_date('2013/02/21 18:00:00','YYYY/MM/DD HH24:MI:SS') order by last_ddl_time desc ;