Q

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?

This Content Component encountered an error
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

Dig deeper on Oracle database backup and recovery

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close