解决ORA-39166: Object CCXE.RR_JYRESEARCHREPORT was not found错误

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