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 22.214.171.124.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 126.96.36.199.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.