數據泵在導出數據表時會不會帶著附加日志一起導出，可以使用數據泵導入參數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