解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
来源:互联网 发布:代购记账软件 编辑:程序博客网 时间:2024/05/21 07:01
OS环境:linux 5.4
数据库版本:oracle 11.2.0
今天同事给我两个DMP文件,是以DATA_ONLY模式导出的表,然后要我导入到CCXE用户下的CCXE表空间下,我的导入命令如下
impdp ccxe/****@FI directory=king DUMPFILE=RR_JYRESEARCHREPORT.DMP tables='(RR_JYRESEARCHREPORT)' job_name=king
Import: Release 11.2.0.1.0 - Production on Mon May 16 20:45:34 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found.
导入的过程中有报错信息,提示内容是找不到CCXE用户下RR_JYRESEARCHREPORT这个表,开始我以为是directory的设置问题,但是我重建directory后依然报错,最后通过使用metalink的查询,该报错的意思是dmp文件内无法找到属于CCXE用户下CCXE.RR_JYRESEARCHREPORT表,通过和同事沟通,最后才得知该表是从TRANUSER用户下TRANUSER表空间内导出的,找到瓶颈了。看来虽然数据是以DATA_ONLY模式导出的,但是数据内依然记得自己所属的是哪个表空间和用户,如果想解决该问题,需要使用参数REMAP重新定义该表的所属用户和所属表空间,命令如下,执行该命令,导入成功。
impdp ccxe/****@FI DIRECTORY=KING DUMPFILE=RR_JYRESEARCHREPORT.DMP TABLES='(TRANUSER.RR_JYRESEARCHREPORT)' REMAP_SCHEMA=TRANUSER:CCXE REMAP_TABLESPACE=TRANUSER:CCXE job_name=king0516
Import: Release 11.2.0.1.0 - Production on Mon May 16 22:31:07 2011
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "CCXE"."KING0516" successfully loaded/unloaded
Starting "CCXE"."KING0516": ccxe/********@FI DIRECTORY=KING DUMPFILE=RR_JYRESEARCHREPORT.DMP TABLES=(TRANUSER.RR_JYRESEARCHREPORT) REMAP_SCHEMA=TRANUSER:CCXE REMAP_TABLESPACE=TRANUSER:CCXE job_name=king0516
Processing
object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "CCXE"."RR_JYRESEARCHREPORT" 75.77 GB 235122 rows
Job "CCXE"."KING0516" successfully completed at 07:10:50
- 解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
- 解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
- ORA-39168: Object path STATISTICS was not found.
- configure: error: *** libmcrypt was not found 错误解决
- 关于解决vs215c++出现的错误 the windows sdk version for 8.1 was not found
- The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path错误解决
- expdp ORA-39165: Schema DBSNMP was not found
- 解决ORA-08102: index key not found
- 解决编译错误:Property 'value' not found on object of type '_strong id'
- libz was not found
- bisonExe was not found
- 错误:A field or property with the name 'XXX' was not found on the selected data source 解决
- Eclipse 错误提示The superclass "javax.servlet.http.HttpServlet" was not found on the Java Build Path解决办
- [解决]在安装Python PIL 时出现错误: Python version 2.7 required, which was not found in the registry
- JPA During synchronization a new object was found through a relationship that was not marked cascade
- 错误:HttpServlet was not found on the Java
- 错误:HttpServlet was not found on the Java
- 错误:HttpServlet was not found on the Java
- 对Linux内存管理的思考
- shell解析xml文档
- 关于Android中注册以内部类形式写的BroadcastReceiver的问题
- wicket 日期控件之应用
- ListBox脚本控制:项从一个ListBox移动到另一个ListBox
- 解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误
- H264关于RTP协议的实现
- rfc3016:用于MPEG-4视听流的RTP负载格式
- 动态更改WebBrowser数据流内容 (动态修改网页源码)
- 用组策略来管理 SQL SERVER 2008 Auto Shrink database 上
- mac 配置环境变量
- 查看dll中导出量的命令
- adb command
- __dopostback() 缺少对象的诡异问题所在