解决oracle IMP工具导入dmp文件 IMP-00033: Warning: Table “...“ not found in export file 错误

想导入一个Java的dmp解析器中自带的dmp文件报错如下imp c##test/test123 tables\(IGNORE, IGNORE2, TABLE1, TABLE2\) file/par/exptest.dmp Import: Release 19.0.0.0.0 - Production on Sat Apr 4 13:31:28 2026 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0 IMP-00002: failed to open /par/exptest.dmp for read Import file: expdat.dmp /par/exptest.dmp Export file created by EXPORT:V12.01.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) IMP-00403: Warning: This import generated a separate SQL file import_sys which contains DDL that failed due to a privilege issue. . importing SYSTEMs objects into C##TEST IMP-00033: Warning: Table IGNORE not found in export file IMP-00033: Warning: Table IGNORE2 not found in export file IMP-00033: Warning: Table TABLE1 not found in export file IMP-00033: Warning: Table TABLE2 not found in export file Import terminated successfully with warnings.应该不是权限问题因为我已经用sys用户grant dba to c##test;了。看到Warning: the objects were exported by SYSTEM, not by you消息以为数据表是SYSTEM的用如下命令行imp c##test/test123 tables\(IGNORE, IGNORE2, TABLE1, TABLE2\) file/par/exptest.dmp fromusersystem touserc##test结果还是同样的错误。想起有个indexfile参数可以显示imp时执行的语句如下命令行成功了。[oracle113bf6abbd59 par]$ imp c##test/test123 file/par/exptest.dmp FULLY ignorey indexfile/par/indexf2.sql Import: Release 19.0.0.0.0 - Production on Sat Apr 4 23:58:12 2026 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0 Export file created by EXPORT:V12.01.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) IMP-00403: Warning: This import generated a separate SQL file import_sys which contains DDL that failed due to a privilege issue. . . skipping table IGNORE . . skipping table IGNORE2 . . skipping table TABLE1 . . skipping table TABLE2 Import terminated successfully with warnings.从过程中可以看到这4个表确实存在。打开/par/indexf2.sql文件明白了REM CREATE TABLE EXPTEST.IGNORE (COLUMN1 VARCHAR2(20)) PCTFREE 10 REM PCTUSED 40 INITRANS 1 MAXTRANS 255 TABLESPACE USERS LOGGING REM NOCOMPRESS ; ...原来表的schema是EXPTEST而不是SYSTEM用如下命令行导入成功。[oracle113bf6abbd59 par]$ imp c##test/test123 fromuserEXPTEST touserc##test tables\(IGNORE, IGNORE2, TABLE1, TABLE2\) file/par/exptest.dmp Import: Release 19.0.0.0.0 - Production on Sun Apr 5 00:03:32 2026 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0 Export file created by EXPORT:V12.01.00 via conventional path Warning: the objects were exported by SYSTEM, not by you import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses AL32UTF8 character set (possible charset conversion) IMP-00403: Warning: This import generated a separate SQL file import_sys which contains DDL that failed due to a privilege issue. . importing EXPTESTs objects into C##TEST . . importing table IGNORE 0 rows imported . . importing table IGNORE2 0 rows imported . . importing table TABLE1 7 rows imported . . importing table TABLE2 4 rows imported Import terminated successfully with warnings.