Home » RDBMS Server » Server Utilities » ORA-31693: Table data object failed to load/unload and is being skipped due to error (11g, 11.2.0.1 window server 2008)
ORA-31693: Table data object failed to load/unload and is being skipped due to error [message #642087] Wed, 02 September 2015 06:54 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

While importing dump from database version 11.2.0.4 to 11.2.0.1 error pop up. We have done it with using parameter "DATA_OPTIONS = SKIP_CONSTRAINT_ERRORS" & without using the parameter "version" but found same error.

Below is the part of export log file.

;;; 
Export: Release 11.2.0.4.0 - Production on Wed Sep 2 10:22:30 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_19":  system/******** DIRECTORY=DP_DIR DUMPFILE=EXPDP_PRODDB_020915_10_22.dmp LOGFILE=EXPDP_PRODDB_020915_10_22.log full=Y version=11.2.0.1 exclude=statistics 
Estimate in progress using BLOCKS method...



Below is the part of import log file.

;;; 
Import: Release 11.2.0.1.0 - Production on Wed Sep 2 10:46:47 2015

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_SCHEMA_01":  system/******** dumpfile=EXPDP_PRODDB_020915_10_22.dmp directory=dp_dir logfile=imp_PREPROD.log SCHEMAS=HLTHCHK,RILOG,infs,multcurr,DMS,UW,DW,DW_REP,INS,GEN,CNFG,REINS,SUMMUSER,CMS,BATJOB,CLM,RNL,rateeng,accext,MIISMA,CONFSYS 
Processing object type DATABASE_EXPORT/SCHEMA/USER


Below is the error of import log file.

ORA-31693: Table data object "CONFSYS"."CNFGTR_CNUM_DEP_SGMNT" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-26097: unsupported conversion for column SYS_NC0000500006$ (from type 58 to type 23)


Please suggest how can I import the same on database 11.2.0.1?

Regards,
Ashish Kumar Mahanta
Re: ORA-31693: Table data object failed to load/unload and is being skipped due to error [message #642088 is a reply to message #642087] Wed, 02 September 2015 07:46 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please post the table definition for "CONFSYS"."CNFGTR_CNUM_DEP_SGMNT"
Re: ORA-31693: Table data object failed to load/unload and is being skipped due to error [message #642089 is a reply to message #642088] Wed, 02 September 2015 07:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please see if Metalink note 1465339.1 applies.
Re: ORA-31693: Table data object failed to load/unload and is being skipped due to error [message #642090 is a reply to message #642089] Wed, 02 September 2015 08:02 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please post the table definition for "CONFSYS"."CNFGTR_CNUM_DEP_SGMNT" from both databases since it appears they are different
Previous Topic: Expdp/Impdp in Oracle 12c
Next Topic: SQLLDR
Goto Forum:
  


Current Time: Tue Nov 30 02:31:11 CST 2021