E-ORA: Unicode conversion fails with ""IMP-00058: ORACLE error 1403 encounter
Last updated on FEBRUARY 20, 2012
Applies to:PeopleSoft Enterprise PT PeopleTools - Version: 8.1
Information in this document applies to any platform.
SPECIFIC TO:�� Enterprise,��ORACLE
This document was previously published as Customer Connection Solution 201069547
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"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms