10g,11g数据泵的导入问题及解决(19天)

今天在环境上测试expdp/impdp,环境有10.2.0.5.0,11.2.0.2.0的,11g的环境是从10g升级到11gde .是在impdp的时候都报了错误。

10g报错如下:

> impdp test/test dumpfile=a.dmp directory=true_dump tables=test_table

Import: Release 10.2.0.5.0 - 64bit Production on Tuesday, 29 October, 2013 17:24:12

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-31655: no data or metadata objects selected for job Master table "TEST"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "TEST"."SYS_IMPORT_TABLE_01": test/********@xxxxx dumpfile=a.dmp directory=a_dump tables=test_table Job "TEST"."SYS_IMPORT_TABLE_01" successfully completed at 17:24:15

11g报错如下:

> impdp temp_usg/temp_usg directory=expdp_dir dumpfile=a.dmp tables=tet_table

Import: Release 11.2.0.2.0 - Production on Tue Oct 29 19:47:17 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-39166: Object TEMP_USG.TEST_TABLE was not found.

最后尝试使用remap_schema 和tables选项,还是报错。

10g报错:

> impdp test/test dumpfile=a.dmp directory=a_dump remap_schema=trudbo24:test tables=test_table

Import: Release 10.2.0.5.0 - 64bit Production on Tuesday, 29 October, 2013 18:03:40

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

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-31655: no data or metadata objects selected for job Master table "TEST"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "TEST"."SYS_IMPORT_TABLE_01": test/********@truabp1 dumpfile=a.dmp directory=true_dump remap_schema=trudbo24:test tables=csm_offer Job "TEST"."SYS_IMPORT_TABLE_01" successfully completed at 18:03:43

11g报错:

Import: Release 11.2.0.2.0 - Production on Tue Oct 29 19:49:32 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options ORA-39002: invalid operation ORA-39166: Object TEMP_USG.TEST_TABLE was not found.

最后在tables的地方加上schema名称,可以顺利导入了。 impdp test/test dumpfile=a.dmp directory=a_dump remap_schema=testo24:test tables=testo24.test_table

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Master table "TEST"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded Starting "TEST"."SYS_IMPORT_TABLE_01": test/********

dumpfile=a.dmp directory=a_dump remap_schema=testo24:test tables=testo24.test_table

Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . . imported "TEST"."TEST_TABLE" 1.622 MB 1939 rows Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Job "TEST"."SYS_IMPORT_TABLE_01" successfully completed at 18:04:33 查找metalink,也有一个类似的bug,看来只能这样先用了。

原文发布于微信公众号 - 杨建荣的学习笔记(jianrong-notes)

原文发表时间:2014-03-22

本文参与腾讯云自媒体分享计划,欢迎正在阅读的你也加入,一起分享。

发表于

我来说两句

0 条评论
登录 后参与评论

相关文章

来自专栏Jerry的SAP技术分享

ABAP OPEN SQL里OPEN CURSOR和SELECT的比较

After the OPEN CURSOR statement, the database cursor is positioned in front of t...

3819
来自专栏python3

数据库分批导出为csv文件

1362
来自专栏杨建荣的学习笔记

impdp异常中断导致的问题(r2第8天)

今天查看数据库的负载,发现cpu消耗异常的高。里面有不少dw的进程.但是查看impdp的进程却不存在。 查看datapump的进程情况,发现大量的job,但是状...

39211
来自专栏杨建荣的学习笔记

ORA-00439的解决(笔记93天)

今天用gc配置了stream后,重启数据库后发现有以下的问题 SQL> startup ORA-00439: feature not enabled: Real...

34910
来自专栏数据库新发现

Oracle诊断案例-Job任务停止执行[最终版]

Last Updated: Friday, 2004-11-26 9:48 Eygle

1263
来自专栏杨建荣的学习笔记

使用句柄实现特定场景的无备份恢复 (r3笔记第61天)

在dba的工作中,备份是一切工作的基础。如果没有备份,本来很简单的恢复工作也会难上加难,如果业务数据要求很高,造成数据的丢失或者损坏,就是重大事故了。 使用rm...

3517
来自专栏耕耘实录

记一次生产环境MySQL数据库的备份与还原

版权声明:本文为耕耘实录原创文章,各大自媒体平台同步更新。欢迎转载,转载请注明出处,谢谢

1084
来自专栏dalaoyang

SpringBoot整合Mybatis

介绍一下SpringBoot整合mybatis,数据库选用的是mysql。 首先创建数据库 CREATE DATABASE test; 建表以及插入初始数据(s...

4406
来自专栏龙首琴剑庐

mybaits3整合spring总结

1、maven定义properties: <org.springframework.version>4.3.1.RELEASE</org.springframe...

3677
来自专栏数据库新发现

Oracle诊断案例-Sql_trace之二

http://www.eygle.com/case/sql_trace_2.htm

1124

扫码关注云+社区

领取腾讯云代金券