EXPDP - ORA-31693 ORA-01466 (table Definition Has Changed) On SYSMAN.EM_SYSAVAIL_COMP_TARGETS (Doc ID 1905612.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.6 to 12.1.0.6.0 [Release 11.1 to 12.1]
Oracle Database - Standard Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Oracle Database - Personal Edition - Version 11.1.0.6 to 12.1.0.2 [Release 11.1 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 22-Jan-2016***

Symptoms

When running a consistent Export Data Pump job from an Enterprise Manager Repository, the following errors occur:

Export: Release 11.2.0.3.0 - Production on Wed Jul 9 09:14:03 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** DIRECTORY=my_dir DUMPFILE=expdp_EMREP_Full_%U.dmp LOGFILE=expdp_EMREP_Full.log REUSE_DUMPFILES=y FULL=y PARALLEL=3 FLASHBACK_TIME=systimestamp
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 10.53 GB
...
. . exported "SYSMAN"."EM_EXADATA_LUN"                   24.78 KB     168 rows
. . exported "SYSMAN"."EM_EXADATA_LUN_PDISKS"            13.45 KB     168 rows
ORA-31693: Table data object "SYSMAN"."EM_SYSAVAIL_COMP_TARGETS" 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 "SYSMAN"."EM_EXADATA_PDISK_LUNS"            15.97 KB     168 rows
. . exported "SYSMAN"."EM_SYSAVAIL_PARAMETERS"           5.554 KB       6 rows
...
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
  /u01/app/oracle/admin/EMREP/dpdump/expdp_EMREP_Full_01.dmp
  /u01/app/oracle/admin/EMREP/dpdump/expdp_EMREP_Full_02.dmp
  /u01/app/oracle/admin/EMREP/dpdump/expdp_EMREP_Full_03.dmp
Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 09:22:43

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms