ORA-02354: ORA-01466: unable to read data - table definition has changed

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 &  

 

 

 

報錯資訊如下： 

 

. . 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:

 

 

查詢了一下， 說是在匯出過程中對錶有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 ;