Hi All,
I am developing an application using Oracle Database Standard Edition 2.
I have taken backup(export) of my database using the utility EXPDP. I am using UTF8 character set
Now i am importing the database using the utility IMPDP in different system. In this system Character set is AL16UTF8
following error has been occured.
I have pasted my log file errors..
;;;
Import: Release 12.1.0.2.0 - Production on Thu Oct 27 15:00:27 2016
Copyright (c) 1982, 2015, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Master table "RMVER16"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in UTF8 character set and AL16UTF16 NCHAR character set
Starting "RMVER16"."SYS_IMPORT_FULL_01": userid=RMVER16/********@PDBDB12 directory=c_dir dumpfile=RMVER15_DUMP.DMP logfile=IMP_RMVER15_27_OCT.txt remap_schema=RMVER15:RMVER16
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/DB_LINK
Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
import done in AL32UTF8 character set and AL16UTF16 NCHAR character set
export done in UTF8 character set and AL16UTF16 NCHAR character set
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "RMVER16"."WFM_LBR_ALLOC_LN_HIST" 6.062 KB 51 rows
. . imported "RMVER16"."LOT_SER_STOCK_TRANS" 17.46 MB 1368031 rows
ORA-02374: conversion error loading table "RMVER16"."EMPLOYEES"
ORA-12899: value too large for column EMP_RECR_SEL_FLAG (actual: 3, maximum: 1)
ORA-02372: data for row: EMP_RECR_SEL_FLAG : 0X'A8'
ORA-02374: conversion error loading table "RMVER16"."EMPLOYEES"
ORA-12899: value too large for column EMP_RECR_SEL_FLAG (actual: 3, maximum: 1)
ORA-02372: data for row: EMP_RECR_SEL_FLAG : 0X'A8'
....
.....
...
. . imported "RMVER16"."SALES_ORDER_ALLOC_LN" 21.23 KB 927 rows
ORA-31693: Table data object "RMVER16"."SALES_RETURN_LN" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kpudpcs_ccs-1], [], [], [], [], [], [], [], [], [], [], []
. . imported "RMVER16"."SAL_ATTACH_HD" 5.664 KB 2 rows
....
.....
.....
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/AUDIT_OBJ
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/PROCEDURE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/JAVA_SOURCE/JAVA_SOURCE
Processing object type SCHEMA_EXPORT/JAVA_CLASS/JAVA_CLASS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
How to solve this problem?
Thanks in Advance,
Su.gi