ORA-39001，ORA-39023，ORA-06502
使用expdp成功从源数据库导出一个schema的dump文件，经详细检查过程中没有任何错误；将文件下载到目标操作系统上用impdp导入时总是提示那三个错误，两个数据库的版本和字符集都是一样的，version的参数值无论是用compatible还是latest都报同样的错误，纠缠了很久实在找不到原因，请高手帮忙，先谢了！
- 源数据库：
- Linux 64 Bit
- Oracle 11.2.0.1.0 64Bit
- 字符集 UTF-8
- 目标数据库：
- win7 64 Bit
- Oracle 11.2.0.1.0 64Bit
- 字符集 UTF-8
C:\>impdp IMPEXP/IMPEXP@ORCL schemas=schema1 directory=dir1 dumpfile=
schema1 .dmp LOGFILE=
schema1 .log content=all version=LATEST;
Import: Release 11.2.0.1.0 - Production on Fri Jun 8 17:27:04 2012
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 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39023: Version LATEST; is not supported.
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
两个数据库的字符集查询结果完全相同：
select * from nls_database_parameters;
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN
NLS_TERRITORY
AMERICA
NLS_CURRENCY
$
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_ISO_CURRENCY
AMERICA
NLS_NUMERIC_CHARACTERS
.,
NLS_CHARACTERSET
AL32UTF8
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CALENDAR
GREGORIAN
NLS_DATE_FORMAT
DD-MON-RR
NLS_DATE_LANGUAGE
AMERICAN
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_SORT
BINARY
NLS_TIME_FORMAT
HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY
$
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_COMP
BINARY
NLS_LENGTH_SEMANTICS
BYTE
NLS_NCHAR_CONV_EXCP
FALSE
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16
NLS_RDBMS_VERSION
11.2.0.1.0
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14415092/viewspace-732325/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
没有了~
下一篇：
没有了~
请登录后发表评论
登录
全部评论
