娱乐彩金21-超导体发炎很干

首页

AD联系:507867812

娱乐彩金21

时间:2019-11-22 06:23:41 作者:现金娱乐代理 浏览量:29698

娱乐彩金21impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619,见下图

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619,见下图

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619,如下图

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

impdp报错ORA-39001、ORA-39000、ORA-31619

如下图

impdp报错ORA-39001、ORA-39000、ORA-31619,如下图

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619,见图

娱乐彩金21impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619。

impdp报错ORA-39001、ORA-39000、ORA-31619

娱乐彩金21

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

impdp报错ORA-39001、ORA-39000、ORA-31619

1.

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

2.

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

3.

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

4.impdp报错ORA-39001、ORA-39000、ORA-31619。

impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuximpdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619impdp报错ORA-39001、ORA-39000、ORA-31619。娱乐彩金21

展开全文
相关文章
宝马娱乐信誉在线投注

impdp报错ORA-39001、ORA-39000、ORA-31619

网上ag是如何作假

impdp报错ORA-39001、ORA-39000、ORA-31619....

国外赌场老虎机攻略

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

国际联邦国际娱

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

老华东会国际娱

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

相关资讯
大赢家电玩城新手卡

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

真钱棋牌

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

乐虎国际注册账号

前不久使用数据泵工具impdp进行数据导入时,遇到报错,提示无效的dunp文件,通过查询文档才知道是由于因为从高版本到低版本不兼容导致的,下面分享一下解决方法。

导入报错

C:\Documents and Settings\hoegh>impdp hoeghto/ilovehoegh directory=data_pump_directorydumpfile=20150826dynamic.dmp remap_schema= hoeghfrom:hoeghto remap_tablespace= hoeghfrom:hoeghto

Import: Release 10.1.0.2.0 - Production on 星期二, 01 9月, 2015 9:31

Copyright (c) 2003, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc

tion

With the Partitioning, OLAP and Data Mining options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31619: invalid dump file "d:\data_pump_directory150826dynamic.dmp"

C:\Documents and Settings\hoegh>

源端数据库版本

SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for 64-bit Windows: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL>

目标端数据库版本

SQL>SQL> select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod

PL/SQL Release 10.1.0.2.0 - Production

CORE 10.1.0.2.0 Production

TNS for 32-bit Windows: Version 10.1.0.2.0 - Production

NLSRTL Version 10.1.0.2.0 - Production

SQL>

添加version参数 源端数据库版本10.2.0.4.0,目标端数据库版本10.1.0.2.0,源端数据库版本高于目标端数据库版本;解决的办法很简单,从源端数据库导出数据时加上目标端version即可,参看一下sql语句:

expdp hoeghfrom/ilovehoegh directory=data_pump_directory dumpfile=20150826dynamic.dmp tables=(HOEGH) version=10.1.0.2.0

接下来,我们再次执行impdp语句就ok了。

impdp时遇到ORA-31693&ORA-31640&ORA-19505&ORA-27037 http://www.linuxidc.com/Linux/2015-06/119232.htm

Oracle导入导出expdp IMPDP详解 http://www.linuxidc.com/Linux/2014-04/99932.htm

Oracle 10g expdp导出报错ORA-4031的解决方法 http://www.linuxidc.com/Linux/2014-04/99842.htm

Oracle 10gr2 rac expdp 报错UDE-00008 ORA-31626 http://www.linuxidc.com/Linux/2014-03/98984.htm

Oracle中利用expdp/impdp备份数据库的使用说明 http://www.linuxidc.com/Linux/2014-01/95568.htm

Oracle备份还原(expdp/impdp) http://www.linuxidc.com/Linux/2014-06/102789.htm

impdp ORA-39002,ORA-39166,ORA-39164的问题及解决 http://www.linuxidc.com/Linux/2014-06/103514.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

热门资讯