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 ;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/35489/viewspace-754468/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/35489/viewspace-754468/