E-ORA: Unicode conversion fails with ""IMP-00058: ORACLE error 1403 encounter (Doc ID 662234.1)

Last updated on FEBRUARY 20, 2012

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version: 8.1 and later   [Release: 8.1 and later ]
Information in this document applies to any platform.
SPECIFIC TO:�� Enterprise,��ORACLE

This document was previously published as Customer Connection Solution 201069547

Symptoms



In the process of  converting  from Non unicode database(WE8ISO8859P1) to Unicode database (UTF8) of the PeopleSoft HR applications Rel 9 and tools 8.48.08  using "Converting PeopleSoft System to Unicode Database" documentation . While  importing the table structures to the unicode database, the source data types of BLOB and CLOB  were  imported as Long RAW and Long.  After that  when  importing  the data to the unicode database,  getting following errors due to the fact that the data type for the column is incorrect.  How  to resolve this?


"IMP-00058: ORACLE error 1403 encountered
ORA-01403: no data found
IMP-00058: ORACLE error 932 encountered
ORA-00932: inconsistent datatypes: expected %s got %s
IMP-00028: partial import of previous table rolled back: 2 rows rolled back"

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