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?

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: