数据泵在导出数据表时会不会带着附加日志一起导出，可以使用数据泵导入参数sqlfile进行sql追踪。

实验

1.新建测试表

SQL> create table Benjamin.tb_test (id int);
Table created.SQL> alter table Benjamin.tb_test add supplemental log data(all) columns;
Table altered.

2.数据泵导出(content=metadata_only与本次测试结果一致)

$ expdp Benjamin/Benjamin@192.168.66.101/pdb_orcl directory=dumpdir dumpfile=EXP.DMP logfile=IMP.log tables=Benjamin.tb_test;
Export: Release 19.0.0.0.0 - Production on Fri Jun 20 22:33:03 2025
Version 19.24.0.0.0Copyright (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
Starting "BENJAMIN"."SYS_EXPORT_TABLE_01":  Benjamin/********@192.168.66.101/pdb_orcl directory=dumpdir dumpfile=EXP.DMP logfile=IMP.log tables=Benjamin.tb_test
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "BENJAMIN"."TB_TEST"                            0 KB       0 rows
Master table "BENJAMIN"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for BENJAMIN.SYS_EXPORT_TABLE_01 is:/data/dumpdir/EXP.DMP
Job "BENJAMIN"."SYS_EXPORT_TABLE_01" successfully completed at Fri Jun 20 22:33:25 2025 elapsed 0 00:00:17

3.数据泵导入

$ impdp Benjamin/Benjamin@192.168.66.101/pdb_orcl directory=dumpdir dumpfile=EXP.DMP logfile=IMP1.log sqlfile=imptab.sqlImport: Release 19.0.0.0.0 - Production on Fri Jun 20 22:35:22 2025
Version 19.24.0.0.0Copyright (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
Master table "BENJAMIN"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "BENJAMIN"."SYS_SQL_FILE_FULL_01":  Benjamin/********@192.168.66.101/pdb_orcl directory=dumpdir dumpfile=EXP.DMP logfile=IMP1.log sqlfile=imptab.sql
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "BENJAMIN"."SYS_SQL_FILE_FULL_01" successfully completed at Fri Jun 20 22:35:23 2025 elapsed 0 00:00:01

4.impdp导出

[oracle@node1 dumpdir]$ cat imptab.sql
-- CONNECT BENJAMIN
ALTER SESSION SET EVENTS '10150 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10904 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10407 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '10851 TRACE NAME CONTEXT FOREVER, LEVEL 1';
ALTER SESSION SET EVENTS '22830 TRACE NAME CONTEXT FOREVER, LEVEL 192 ';
-- new object type path: TABLE_EXPORT/TABLE/TABLE
CREATE TABLE "BENJAMIN"."TB_TEST"(    "ID" NUMBER(*,0)) SEGMENT CREATION DEFERREDPCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255NOCOMPRESS LOGGINGTABLESPACE "USERS" ;
-- new object type path: TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ALTER TABLE "BENJAMIN"."TB_TEST" ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
-- new object type path: TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS