oracle转储文件集设置,确定现有Oracle数据库转储文件的NLS_LANG设置

在unix上最简单的方法是：

#>imp username/password file=test.dmp show=y

Import: Release 10.2.0.3.0 - Production on Fri Nov 26 08:38:47 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

Export file created by EXPORT:V10.02.01 via conventional path

import done in US7ASCII character set and AL16UTF16 NCHAR character set

import server uses WE8ISO8859P1 character set (possible charset conversion)

版本exp / imp是一个问题：

我通常使用V10导出程序并使其连接到V11数据库.

确保你在dev10的oracle_home中的tnsnames.ora中有dev11的别名.

hostname{oracle}# . oraenv

ORACLE_SID = [oracle] ? dev10

hostname{oracle}#

hostname{oracle}#>exp username/password@dev11 full=y dumpfile=dump.exp