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
] 
Blog
Search
Help
Members
Register
Login
Home
