ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-39001,ORA-39023,ORA-06502

ORA-39001,ORA-39023,ORA-06502

原创 Linux操作系统 作者:HaveAJaguar 时间:2012-06-08 17:25:39 0 删除 编辑
使用expdp成功从源数据库导出一个schema的dump文件,经详细检查过程中没有任何错误;将文件下载到目标操作系统上用impdp导入时总是提示那三个错误,两个数据库的版本和字符集都是一样的,version的参数值无论是用compatible还是latest都报同样的错误,纠缠了很久实在找不到原因,请高手帮忙,先谢了!
  • 源数据库:
  1. Linux 64 Bit
  2. Oracle 11.2.0.1.0  64Bit
  3. 字符集 UTF-8
  • 目标数据库:
  1. win7 64 Bit
  2. Oracle 11.2.0.1.0  64Bit
  3. 字符集 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博客 ” ,链接:http://blog.itpub.net/14415092/viewspace-732325/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 没有了~
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2012-06-08

  • 博文量
    1
  • 访问量
    6706