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.
Best Answer
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.