This content has been marked as final. Show 1 reply
You may be a victim of this bug
Bug 10629770 - KEYWORD "CHAR" INDICATING CHAR SEMANTICS IS MISSING FROM OUTPUT DATA TYPE STRING
When an attribute is specified with CHAR or VARCHAR2 data type having char
semantics, e.g., CHAR(3 CHAR) or VARCHAR2(60 CHAR), the output data type
string for the attribute in the exported xml doesn't contain the CHAR
Without "CHAR" keyword, the RDBMS will assume the default "BYTE" semantics.
Datapump and EIF both internally generate XML, which is then imported into the new database.