Just be try. env oracle 19.3 PDB.

创建测试表 2张

SQL> create table anbob.test_exp as select * from all_objects;

Table created.

SQL> insert into anbob.test_exp select * from anbob.test_exp;

71615 rows created.

SQL> commit;

Commit complete.


SQL> create table anbob.test_exp2 as select * from all_objects;

Table created.

SQL> @seg anbob.test_exp

    SEG_MB OWNER                SEGMENT_NAME                   SEG_PART_NAME                  SEGMENT_TYPE         SEG_TABLESPACE_NAME                BLOCKS     HDRFIL     HDRBLK
---------- -------------------- ------------------------------ ------------------------------ -------------------- ------------------------------ ---------- ---------- ----------
        23 ANBOB                TEST_EXP                                                      TABLE                USERS                                2944         12       6929
        12 ANBOB                TEST_EXP2                                                     TABLE                USERS                                1536         12       4890

导出2张表 到多个dmp文件

[oracle@oel7db1 ~]$ exp anbob/anbob@cdb1pdb1 tables=test_exp,test_exp2 filesize=5m file=testexp1.dmp,testexp2.dmp,testexp3.dmp,testexp4.dmp,testexp5.dmp,testexp6.dmp,testexp7.dmp,testexp8.dmp

Export: Release 19.0.0.0.0 - Production on Tue Jul 6 05:32:32 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)

About to export specified tables via Conventional Path ...
. . exporting table                       TEST_EXP
continuing export into file testexp2.dmp

continuing export into file testexp3.dmp

continuing export into file testexp4.dmp

continuing export into file testexp5.dmp
     143230 rows exported
EXP-00091: Exporting questionable statistics.
. . exporting table                      TEST_EXP2
continuing export into file testexp6.dmp

continuing export into file testexp7.dmp
      71623 rows exported
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.

删除表1

[oracle@oel7db1 ~]$ 

[oracle@oel7db1 ~]$ sqlplus anbob/anbob@cdb1pdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Tue Jul 6 05:33:13 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Tue Jul 06 2021 05:32:32 -04:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0


USERNAME             INST_NAME            HOST_NAME                  I# SID   SERIAL#  VERSION    STARTED  SPID       OPID  CPID            SADDR            PADDR
-------------------- -------------------- ------------------------- --- ----- -------- ---------- -------- ---------- ----- --------------- ---------------- ----------------
ANBOB                PDB1-anbob19c        oel7db1                     1 127   42096    19.0.0.0.0 20210706 2971       76    2969            00000000781BB458 0000000078D31668


SQL> drop table test_exp purge;

Table dropped.

导入 表1 只列出部分dmp file

[oracle@oel7db1 ~]$ imp anbob/anbob@cdb1pdb1 tables=test_exp filesize=5m file=testexp1.dmp,testexp2.dmp,testexp3.dmp,testexp4.dmp,testexp5.dmp

Import: Release 19.0.0.0.0 - Production on Tue Jul 6 05:33:35 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

Export file created by EXPORT:V19.00.00 via conventional path
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 ANBOB's objects into ANBOB
. importing ANBOB's objects into ANBOB
. . importing table                     "TEST_EXP"     143230 rows imported
Enter name of the next file in the export file set.
Import file: expdat.dmp >

IMP-00047: unexpected file sequence number; expected 6 but found 5    <<<<<<
IMP-00132: first file in the multi-file export is testexp1.dmp
IMP-00008: unrecognized statement in the export file:
  URCE
IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:

IMP-00008: unrecognized statement in the export file:
...

Note:
表记录已导入，但是会判断文件完整性，提示dmp文件未列全

验证数据

SQL> @cc pdb1
ALTER SESSION SET container = pdb1;

Session altered.


USERNAME             INST_NAME            HOST_NAME                  I# SID   SERIAL#  VERSION    STARTED  SPID       OPID  CPID            SADDR            PADDR
-------------------- -------------------- ------------------------- --- ----- -------- ---------- -------- ---------- ----- --------------- ---------------- ----------------
SYS                  PDB1-anbob19c        oel7db1                     1 127   56272    19.0.0.0.0 20210706 3019       48    3018            00000000781BB458 0000000078D0BFE8


SQL> select count(*) from anbob.test_exp;

  COUNT(*)
----------
    143230