解决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 SYSTEM's 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 fromuser=system touser=c##test结果还是同样的错误。
想起有个indexfile参数可以显示imp时执行的语句，如下命令行成功了。
[oracle@113bf6abbd59 par]$ imp c##test/test123 file=/par/exptest.dmp FULL=Y ignore=y 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，用如下命令行，导入成功。
[oracle@113bf6abbd59 par]$ imp c##test/test123 fromuser=EXPTEST touser=c##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 EXPTEST's 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.