Characterset mismatch error during import
I have an Oracle 8i dump file, version 8.1.5. I need to import
it to the target machine where I have Oracle 8i version 8.1.7 installed.
While importing I noticed a characterset mismatch error and I failed to import
it. Can you please help me with this?
When you import a dump file, the database will attempt a characterset conversion if possible. Depending on the source and destination charactersets, this may not be possible. It appears that an automatic characterset conversion is not possible in our case.
To solve this, I would create a new database with the same characterset as your dump file. I would then perform the import. Since the dump file and the database are the same characterset, you should not have any issues with the import. Once the data has been imported, I would change the database's characterset to match the destination characterset you desire. You can them export from this "temporary" database and then import to your final destination. Once done, simply remove your temporary tablespace.
This was first published in September 2005