HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Importing a different character set export dump into another DB instance

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
dumpintocharacterdifferentinstanceexportanotherimportingset

Problem

I am trying to import a given dump file using oracle imp utility.
However; I am facing the following issues.

C:\Users\AD>imp DB_USER/*****@dev1 file=C:\test\db42312.dmp log=C:\test\import2.log

Import: Release 11.2.0.1.0 - Production on Thu Apr 10 13:37:47 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully

C:\Users\AD>


My source DB yields following results for the NLS query

SQL> select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');

PARAMETER           VALUE
----------          ---------
NLS_LANGUAGE        FRENCH
NLS_CHARACTERSET    AL32UTF8

SQL>


And my destination DB yields the following results:

SQL> select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');

PARAMETER           VALUE
----------          ---------
NLS_LANGUAGE        AMERICAN
NLS_CHARACTERSET    AL32UTF8

SQL>


The issue that I face while executing the import command seems like a character set issue.

Is it possible to import the database dump onto my new (but blank) schema? Please note that I already have other databases on the same server.

Solution

For me it was the imp command that was wrong. The dump I got was taken using expdp and I was trying to import it with imp.

Got imported using impdp command.

Context

StackExchange Database Administrators Q#63741, answer score: 3

Revisions (0)

No revisions yet.