在用使用oracle数据泵导入指定数据时候报了一个这样的错误,网上了很久也没解决的方法,于是自己琢磨一下后就解决了,希望能够帮助遇到同样问题的小伙伴,但不能保证能对你们一定有作用,仅供参考,觉得不错点个赞
oracle版本为11g windows7服务端操作
具体报错信息如下:
Microsoft Windows [版本 6.1.7601] 版权所有 (c) 2009 Microsoft Corporation。保留所有权利。 C:\Users\Administrator.USER-20190408KO>e: E:\>cd E:\work\develop\oracle11g_11_2_0\product\11.2.0\dbhome_1\BIN E:\work\develop\oracle11g_11_2_0\product\11.2.0\dbhome_1\BIN>impdp szzxs/szzxs@1 27.0.0.1:1521/orcl directory=bigdata dumpfile=WSDTRDG23123.dmp REMAP_TABL ESPACE=RESMG:SZZXSPACE remap_schema=lwsys:szzxs table_exists_action=replace Import: Release 11.2.0.1.0 - Production on Thu Oct 31 14:07:03 2019 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-39146: schema "LWSYS" does not exist Master table "SZZXS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded Starting "SZZXS"."SYS_IMPORT_FULL_01": szzxs/********@127.0.0.1:1521/orcl direc tory=bigdata dumpfile=WSDTRDG23123.dmp REMAP_TABLESPACE=RESMG:SZZXSPACE r emap_schema=lwsys:szzxs table_exists_action=replace Processing object type TABLE_EXPORT/TABLE/TABLE Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS ORA-39112: Dependent object type INDEX_STATISTICS skipped, base object type INDE X:"RESMG"."WSDTRDG23123_INS" creation failed Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS Job "SZZXS"."SYS_IMPORT_FULL_01" completed with 7 error(s) at 14:07:06解决办法: 新建一个RESMG的用户进行目录授权后,再把需要数据重新导入到此用户下就解决了~