Hi all,
I trying to transfer database form production server into test machine with exp/imp command.
exp system/*****@szpital dumpfile=backup.dmp full=y logfile=dump.log
On production server I have log which says:
Master table "SYSTEM"."SYS_EXPORT_FULL_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_FULL_01 is:
/opt/app/oracle/sklad/backup.dmp
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Mon Mar 21 00:44:38 2016 elapsed 0 00:14:34
Next I transfering database witch scp command (md5sum are match on servers).
After this I issue command:
imp system/*****
Import: Release 11.2.0.4.0 - Production on Mon Mar 21 13:29:00 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Import data only (yes/no): no > no
Import file: expdat.dmp > backup.dmp
Enter insert buffer size (minimum is 8192) 30720> 8192
IMP-00038: Could not convert to environment character set's handle
IMP-00000: Import terminated unsuccessfully
Additional information production and test side are same:
select * from v$nls_parameters where parameter in ('NLS_CHARACTERSET','NLS_LANGUAGE');
NLS_LANGUAGE POLISH
NLS_CHARACTERSET EE8MSWIN1250
Can you advice me what I did wrong?