My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 11.1 to 13.1]
Oracle Database - Standard Edition - Version to [Release 11.1 to 12.2]
Oracle Database - Enterprise Edition - Version to [Release 11.1 to 12.2]
Oracle Database - Personal Edition - Version to [Release 11.1 to 12.2]
Information in this document applies to any platform.


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

Export: Release - 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 - 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...
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:
Job "SYSTEM"."SYS_EXPORT_FULL_01" completed with 1 error(s) at 09:22:43





To view full details, 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 a vibrant support community of peers and Oracle experts.